AnsweredAssumed Answered

Relationship insertion question

Question asked by tomperr on Sep 13, 2018
Latest reply on Sep 14, 2018 by tomperr

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.

Outcomes