AnsweredAssumed Answered

Extra info from table in other table related to drop-down list

Question asked by CarlJacobs on Apr 19, 2011
Latest reply on Apr 22, 2011 by CarlJacobs

Title

Extra info from table in other table related to drop-down list

Post

Hi guys, I need some help on this one. I think it's fairly simple but I can't figure it out:

I have two tables:

CONTACTS

COMPANY

In the CONTACTS table there is:

contact_name
contact_email

In the COMPANY table there is:

company_name
company_contact

There is a = relationship between contact_name and company_contact
I want to select the company_contact via a drop down list from contacts::contact_name
That works.

But then I want the correspondent contact_email from contact_name to appear in the company table (just for reference - no editing needed). When I do this, he always takes the first record in row. How can I achieve this?

Thanks a lot for your intervention!


C.J.

Outcomes