hey guys,
i have just started using access again for the first time in 10 years and i am reteaching myself.
i have this problem i know it is possible but i am unsure on how to achieve it, i believe it would be done with a query.
i have two tables:
batch (table 1)
which contains the following
ID | Date | Prefix | First Number | Last Number | Location | Store / Scan|
Prefix (table 2)
which contains the following
ID | Prefix | Description | Location | Store / Scan |
basicly what i require is when a prefix is entered in table 1 and the prefix matches one in table 2 it collects information regarding Location and store / scan from table 2
as a resault of this when a new batch is created and a prefix assigned the Location and store scan fields are automatically populated with information from the second table.
any help regarding this issue would be greatly appreciated.
Thanks
Turtlesrun