I am currently using dynamic value lists thru relationships to populate records in a table. My problem is that I need a field key auto populated and wondering where would the table relationship best work.
The structure is layout based on "Contacts" table. I am populating the "PrevMaint" table thru portal. The selection process is using value list to select the country. The "Facilities_Country" table to select States within that Country; "Facilities_State" to select available sites that reside in said State. All selections work, but I also need the _FacilitiesIDfk to populate the field key from a "Facilities" table. I am just unsure where the relationship should be to do this.