So, the Person table has 2 IDs (neither is the primary key of the table, like SSN and HRID). What the customer wants is to show both IDs in the Orders table.
I'm having trouble getting the table to populate the second ID field based on what is selected from the drop-down in the first ID field.
Person table (ID, FirstName, LastName, SSN, HRID)
Orders table (ID, PersonSSN, PersonHRID, etc.)
If I populate the Look-up field of PersonSSN as 'Select SSN, HRID from Person' (use column 1 as value),
how do I get the HRID field to populate when someone selects a SSN value from the Person drop-down?
And the follow-up, can I get the same thing to happen in reverse (i.e. populating the PersonSSN value when the customer selects an HRID from the PersonHRID drop-down)?
I'm hoping someone understands what I just wrote, even if you can't help me.
Thanks