Extra info from table in other table related to drop-down list
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:
In the CONTACTS table there is:
In the COMPANY table there is:
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
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!