How can we populate text boxes/fields (in a Form) by linking it to data in a query?
Jay here, and I have been working with my company's small customer client database. I have multiple data entry forms which I use as the frontend to enter data into my tables. However, there is one form, for which, I want to enter data/populate it by data from another table.
[I know its confusing, explained it further below]
The Master Contract (Form) contains policies which are predefined and stored in a separate table. It was suggested to me that the form should have a mechanism/function that:
IF a particular service is selected (in the master contract form) by clicking on the drop-down menu
THEN the fields for that particular service should be populated BY the values in the policy table.
Fields in the Form: Customer_Name, Service Type, Policy1, Policy2, Policy3
Columns/Fields in the Table: Service Type, Policy1, Policy2, Policy3
So, IF I enter a new customer_name and a service_type, then I want to get the Master_Contract_Form to get data from Policy_Table regarding policies related to that particular service_type.
Is there a way to do it? Or the question is still unclear?
I would appreciate any help.