Selecting only one active record from multiple records

M

M.L. Abram

Hello all,

I do not know if this question is regarding table design, queries, or
programming. Below, I have given a table design using Access 2003.
Fields 'Product' and 'Color' are primary keys and 'Active'
is a Boolean data type. What I am trying to accomplish is having only
one record selected active out of the 'Product' field for each
type. If possible, have the user be able to do this task while viewing
the data within a continuous form.

Product Color Active
-----------------------------------------------
Shirt Blue
Shirt Yellow
Shirt Green True
Shirt Red
Shirt Black
Shirt Pink
Shirt White
Pants Blue
Pants Black True
Pants White
....

Thoughts or ideas?

TIA

M.L. Abram
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inactivating records 3
Help with Report 1
Directory merging across, not down 1
Add multiple (2) rows to same table from one form 4
Conditional Formatting w/Requery Causes a Flicker or Flash 9
Moving data from one table to another 2
Multiple drop down lists filtered 3
selecting distinct fields in a record 4

Top