Creating a Listbox/Combobox on a form. 1

[fmasin]

Hi

I have two tables - Table 1: customer (Fields: customerId, Firstname, LastName, Address and Telephone)
Table 2: Service_Hist (Fields: Service_Hist_Id, serv_Date,Description, Total_cost, Customer_Id).

I have created a Master form to view the customer information and their service history.

How can I create a combo box/listbox that allows the user to pick a customer from a drop down menu and the relevant information is displayed in all the other fields? i.e When a user picks the customer, all the other details are displayed....and below in the service history....their service history is displayed as well. How can I?


Thanks and regards,

Francis

 

[R1972]

Hi,

u can use LOV to do ur request i.e with the help of mapping column properties & record group. If u use combo/listbox then use the When-List-Changed trigger, fetch value from table & post into respective items.

 

[fmasin]

Thanks R1972....a star for you!

Thanks and regards,

Francis