Given these relationships:
Leads::_CompanyID = Company::_CompanyID
Contacts::_CompanyID = Company::_CompanyID
ContactID does not serve as a match field in a relationship and thus selecting a value in Leads::_ContactID does not link the current Leads record to any record in Contacts and thus no data appears in your fields.
If you make a new Tutorial: What are Table Occurrences? of Contacts and link it to leads like this:
Leads::_ContactID = Contacts|Leads::_ContactID
Then you can either place fields from Contacts|Leads on your layout or define auto-enter field options for fields in Leads that auto-enter data from Contacts|Leads and they will populate with data when you select a contact in _ContactID.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Okay, I set it up. However, when I select a contact I get an error message that the value is a defined to contain unique value only. Obviously I'm missing something.
That would suggest that you set up the Contacts::_contactID field with this value list format instead of Leads::_ContactID. Either that or you have a unique values validation on the Leads::_ContactID field that should be removed.
I did set it up that way because I'm creating a new Lead record and therefore there aren't any _fkContactID's in the Leads table
That does not change what I suggested in my last post. If you are creating a new Leads record, it must be linked to an existing Contacts record in order to show the needed data. Thus, you need to format the Leads::_fkContactID field with a drop down list of values from the Contacts table.
If this is what you have done and you still get this error message, you need to go to Manage | Database and remove this validation requirement from the _fkContactID field as it should not be specified for a foreign key field on the many side of a
manyone to many relationship.
Thanks very much. Got it.