Jump to content
  • 0

one field in submission form determining the content of a hidden field



I feel like this is a really basic relational database question and I feel like a numpty that I cant make it work. 
I have  submission form to update table "Providers". In that submission form I have a field "Location" with a dropdown populated from a "Locations" table. In that Locations table, each location is a single record with 'Officer' as field.  I'm trying to autopopulate the "Officer' field hidden in the submission form  (for Providers) with the officer data determined from the "Location" selected in the dropdown, by referencing the corresponding Officer in the Locations table. Should this be done using a view or a relationship or both? 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...