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

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.

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

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

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!

hey,

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

Thanks for all your help

ieuuk