I'm pretty sure that there are 2 fields, one over the other, in that layout...
The first showing the ID and the second showing the name.
Isn't it ?
Company Table can have multiple Contacts.
CompanyID would be necessary.
Contacts Table can have only one Company
It should have a CompanyID field linked to Company:CompanyID for the relationship.
There are not at the moment, two fields. Should there be? I do have Company ID linking the tables in the relationships setup. Do I need to include the ID in the layout?
(And don't apologise for your English - it is perfect. Wait till you see my French.....)
Thanks for replying (an Daniele too)
That is how I have it set up. I have a Company ID which is a unique value generated at the entry of the Company name and details record in the Company Info table. The Company Info table and the Contact info table are connected via this ID.
However, when I enter the Contact Info, I would like to be able to choose a company name from the Company info table through a pull-down list, which would then bring along the company ID and insert it in the relevant field in the contact id record. But the pulldown list is not appearing at all. I now have the arrow appearing thanks to some info from my local supplier, but nothing actually happens when you click on it.
So I am stymied.
Thank you for your post.
It sounds like you have the one field set up properly. However, if the arrow isn't showing on the field, are you sure you formatted it properly?
Pull down the View menu and select "Layout Mode". Click on the Company ID field so that there are four anchors on the field.
Pull down the Format menu and select "Field/Control -> Setup..."
Under Control Style, make sure you have Display as: set to "Drop-down List", and make sure you have Display values from: set to the proper value list. Click OK and return to Browse Mode.
Does the arrow appear now with your Company names?
Thanks for the reply.
I did all that, and I did have it all set up as you said. I have the Display Values set at "Company Employing". Under Manage Value Lists I have defined "Company Employing" as the field in "Company Contact Info" that contains the company names. However, although the arrow is now there (since the local rep suggested that I define the borders, at least the right-hand border), it is not showing me the list to choose from. The whole thing stays obstinately blank when I click on it. I think it just has it in for me actually ;^)
Ok, I solved it! At last!
I had defined the field as displaying the field from the Company Contact Info, and then wanted it to choose from a drop-down specified by the same table, (imagine embarrassed smiley here (there aren't any to choose from the drop-down list...)...) instead of asking it to display the field from the indiv contacts, as chosen from a drop-down list from company contacts.
Thanks for all the ideas, everyone!