All,
I am getting stuck on this and need some help please.
I need a value placing in one field dependant upon another field relevant to a list in a sub table like lookup in excel.
I have my master table (T_Main List)
Fields:
ID, Ward & Area & .........
I have a sub table (T_Ward).
Fields:
ID, Ward & Area
In the master table I am adding contact details for relevant locations within the locality
in the sub table there are a list of towns and an area code for each. There are multiple towns in each code
on my form (F_Edit) I have 2 bound combo boxs for Ward and Area linked to the master table.
I would like it when I select a town it will lookup the area code from the table and add it to the area field on the main table
Cheers in advance for any help
I am getting stuck on this and need some help please.
I need a value placing in one field dependant upon another field relevant to a list in a sub table like lookup in excel.
I have my master table (T_Main List)
Fields:
ID, Ward & Area & .........
I have a sub table (T_Ward).
Fields:
ID, Ward & Area
In the master table I am adding contact details for relevant locations within the locality
in the sub table there are a list of towns and an area code for each. There are multiple towns in each code
on my form (F_Edit) I have 2 bound combo boxs for Ward and Area linked to the master table.
I would like it when I select a town it will lookup the area code from the table and add it to the area field on the main table
Cheers in advance for any help