AnsweredAssumed Answered

Related Records Question

Question asked by Ben_B94 on Feb 12, 2016
Latest reply on Feb 12, 2016 by siplus

I have,

 

Locations ----< Tools ----< Signout >----Staff

 

In my tools table I have Location ID foreign key and on the tools layout the foreign key is a dropdown, value list = Location::Site_Name field

 

On my Signout table I have a tools foreign key, and on the signout layout I have a dropdown of the toolIDs which when selected auto-fill related fields I placed on the layout for tools, like category, model etc but it doesnt autofill the location field when I place it. I thought by having a dropdown like above I was setting a particular site for each tool record?

 

Thanks

Outcomes