newbie has a problem...please help me out

[Timon]

Hi,

I am building a datastructure for our small office. My first fase is dock
all data related to our contacts. Therefore I've chosen to build 4 tables:
1. Organisations (organisational data)
2. Contacts (name, gender, etc.)
3. Locations (adress, within a organisation)
4. Departments (to be build, containing information on a department within a
organisation)
I like to recieve comments on my structure, but the reason for this e-mail
is a relational problem: the Table/field 'Organisations/organisation' has a
two-way relation with both 'Contacts/organisation' and
'Locations/organisation'. The tables Contacts and Locations are linked
twice, through relations on the fields '/organisation' and '/location'. In
my contacts layout I've I first describe a contact through a number of
fields, then choose input for organisation (menulist), then I choose input
for the the relational field '/location'. Then I want to see the correct
visiting adress in the same contacts layout (with the fields '/visit adress'
and '/visit place' from the Location-table) but they only show one adress
and do not change when I change the location in the field (i.e. from
'Headquarters Rotterdam' to 'Regional Office The Hague'). It seems the
adress fields only look at the related organisation, but do not look at the
specified location. I hope I've pointed out my problem and I also hope you
can help me. Thanks in advance...

--
Best regards,

Timon

[r...@p.com]

somewhat difficult to comment on TIMON,
please send databases to in...@infortica.be
I might be able to help you (use DUTCH)
is too much work is involved, price offer can be made

Rob Paredis
FileMaker consultant
Belgium - Antwerp
0032 495 5741 12
"Timon" <bloc...@enzowoord.nl> wrote in message
news:bk4c06$mr4$1...@reader11.wxs.nl...