Click here to Skip to main content
15,070,233 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have two columns. The backend is a ms access database.
For column A's single value I have many values of column B.

How can I prevent a redundancy of data in column B?
Can I use a combobox in ms access or any other thing?
I can not make two tables, because it is too large for this problem.
Can anyone help me?
Posted
Updated 21-Nov-10 21:50pm
v2
Comments
Dave Kreskowiak 22-Nov-10 10:47am
   
What do you mean by "prevent redundancy"?? Explain what you it looks like now and what you're trying to get it to look like.

1 solution

Do you mean you want the values in column B to be unique? You can set it as the primary key column.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900