[Jason3]

I am trying to set up a database (beginner) and I do not want any fields to acept any duplicates. For e.g tracking serial numbers of similar model of say a vcr

account No serial number of vcr 1 ...serial number of vcr 1
1 2 3
2 3 2


It will not accept same serial number in one field but i don't want the d.base to accept an existing serial number which is already in a diff field. I don't want to use the p.key 'cause on one account there could be one vcr only. Any suggestions how to solve the problem

Thank u

[OBP]

Why would you have more than one Serial Number field?
Use just oe field and set it to Indexed "With No Duplicates".

[Jason3]

Thanks for the reply.

The reason there a re two serial numbers is that one customer can keep a maximum of two VCR on his acct. IF I USE one field then I'll have to enter the account number each time at every row . So if I want to display the whole thing on a form - I'll see only the first serial number . I s there a way to show all of them ?

[OBP]

The Account Number should be on a Combo Box on a main form and the serial numbers should be on a subform.