Unanswered: Access filling multiple fields from single source
Hi all, hoping for some help.
I have a database that records production data. Within it are 3 fields for selection of products made on a single line, each of those fields is a lookup to a table that contains the product data.
On the main form is a field for Product 1, 2 and 3. What I am trying to do is then have a field that selects the relevant description of that particular product from the products table. However, Access seems determined to only let the Description box show data for Product 1. I am sure there is something really obvious we are missing but we're certainly not experts on this.