how can i relate the tables?
I have a problem...
there are A table and B table.
A table have name field, address field.
B table have three name fields and three address fields in one record.
I want to use A table as preference.
thus what i want is when i input name field in B table, address field is filled automatically.
i success only one name, but can't do it when 2 name field.
how can i do ?
here is my screen shot.