- #1
Shaun Culver
- 69
- 0
I have two tables that I would like to link in a specific way. Both tables have a field name labelled, for example, "Price". Both also have a field name labelled, for example, "Item type".
In the first table, each of my stock items are listed in the "Item type" field, with the corresponding price in the "Price" field.
Now the problem...
In the second table, I have many sales receipt entries, with the item types entered (sorted by date), but no entries in the price field.
How do I automatically transfer the price to the second table based on what is entered in the first table?
In the first table, each of my stock items are listed in the "Item type" field, with the corresponding price in the "Price" field.
Now the problem...
In the second table, I have many sales receipt entries, with the item types entered (sorted by date), but no entries in the price field.
How do I automatically transfer the price to the second table based on what is entered in the first table?