I have been trying to retrieve multiple record set in the form but no avail.
Here is what i would like to do-
the basic is I have 2 tables
table1: have----------- ClientID, firstname, lastname
1 , tom , Duong
table2: have-------------ClientID, order_type,
1 , A
1 , B
1 , C
after i enter in clientID and hit tab I would like to display on form ClientID, firstname, lastname and 3 order_type A,B and C.
I got it to work ClientID, firstname, lastname but I don't know how retrieve all 3 order_type A,B and C.
Please help me, thank you so much in advance..