Unique record with multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really need some help here.
I have a table "products" and a table called "reports". Every record in
"reports" can have up to 3 products listed.
Now here is where I think it gets tricky. I am using a form "ReportFiles" to
search records that meet certain criteria. I want to use a pulldown menu
that will only allow a search on products that have actually been used and
recorded in table reports.
How can I sort 3 columns of product records in a query to list only the
distinct possibilities?
 
It sounds like you are describing a table with three different fields in
which a value (product) might be found. If so, you probably have committed
spreadsheet on Access -- you will have to work hard to make it do what you
described.

Consider looking into HELP topics on "normalization" and "relational
database design".

Good luck

Jeff Boyce
<Access MVP>
 
actually the table is for quality tests. 1 test may be associated with up to
3 products (Product1, Product2, Product3). these are number fields that are
associated with ProductID from a Products table.
 
Back
Top