Hi everyone
So I'm creating an access database using three tables, so far, they are:
tblCompany
tblPrograms
tblSupplementary
The Company table will have one or more than one program and/supplementary service. Thus, the program(s) and supplementary(ies) columns appear as dropdown lists in the Company table. The relationship is 1-to-many for Company and programs/supplementary.
Basically what I aim to achieve is that the user selects the Company from a combobox and the fields (e.g. address, email, program(s), supplementary(ies), etc.) automatically populate the textboxes based off what was selected in the dropdown. I have a form and manually inputted the various textboxes. If anyone has any feedback, that would be much appreciated. Thank you!
So I'm creating an access database using three tables, so far, they are:
tblCompany
tblPrograms
tblSupplementary
The Company table will have one or more than one program and/supplementary service. Thus, the program(s) and supplementary(ies) columns appear as dropdown lists in the Company table. The relationship is 1-to-many for Company and programs/supplementary.
Basically what I aim to achieve is that the user selects the Company from a combobox and the fields (e.g. address, email, program(s), supplementary(ies), etc.) automatically populate the textboxes based off what was selected in the dropdown. I have a form and manually inputted the various textboxes. If anyone has any feedback, that would be much appreciated. Thank you!