lookups

[ieuuk]

Hi All,

I'm wondering if someone can help me out here because i just cannot work out how you would go about doing this... let me explian.

I have 3 tables in a database: companies, addresses, contacts.

So one company can have many contacts and addresses.

What i am trying to do is i have created a drop down box on my contact where i can select what address ID that contact is at... and what i want to be able to do is display the rest of the address details for that address ID but i just cannot work it out.

Any advice is welcome.

Thanks in advance,

ieuuk

[comment]

You need to add a relationship between Contacts and a new occurrence of the Addresses table, matching on AddressID. Once you have that, you can place fields from this occurrence onto the contacts layout.

[ieuuk]

Thank you for the response... i think i must be missing something though.

What i dont appear to be able to get is the address to change with the location ID... not quite sure where im going wrong.

Any ideas?

Thanks,

ieuuk

[comment]

Hard to troubleshoot from here. You can post your file (or even better, a simplified demo) for us to take a look.

[ieuuk]

i've managed to get it to work between another 2 tables so i'll keep hacking away at it an let you know )

Thanks for you help so far!

[ieuuk]

hey,

I managed to fix it - i had the relationship worng )

Thanks for all your help

ieuuk