Problem with tables

[accessgebruiker]

For my work I had to make a database where you can put in all the computers, monitors, printers, supliers, ec..

All computers, monitors and printers have unique "mse numbers".

I made a table computer, a table monitor and a table printer. In all these tables I made a field MSE. But now you can put in every number you want. How can I make it so that you can put in every MSE number once ??

Do I have to make a new table (for example: is it possible to fill this table automaticly ) or is there an easier way ??

I hope you can help me out..

William

 

[KLewisBPM]

If you go to the table properties in design mode, you can select the field mse and set the "indexed" feature to say "yes (no duplicates)" Kind Regards

Kelley Lewis

 

[accessgebruiker]

no.. sorry that's not where I'm looking for.

Becouse if I set "indexed" to "yes (no duplicates)" I just can do this:

In the table computer -> MSE = 5
In the table printer -> MSE = 5 (too)

and what I want is that he gives an (sort of) error if you want to put in the same value.

But thanx anyway

William

If I do something wrong ... just tell me