I have the following problem:
I have a table named "Database", where details about different firms are listed.
I have a table named "Industry Registry", which lists out all 96 industries as listed by the North American Industry Classification System (NAICS, 2017).
I have a table named "Broader Industry Registry", which lists out the 19 broader industry classification as listed by the NAICS.
The Relationships are listed below:
Industry ID will be selected as the data entry is done in "Database". What would I have to do in order to have the field "Broader Industry ID" autocomplete after registering an industry ID?
Each Industry ID corresponds with only only Broader Industry ID.
Thank you for your attention.