Indexing Tables on multiple fields

[bhujanga]

I have a tale with an inventory date field an inventory item and a quantity field. I want to make it so you can duplicate the date as many times as needed for each item that needs inventoried, but also so it won't allow the same date-item pair to appear more than once. It seems like I used to be able to do this sort of thing by indexing both fields and saying 'no duplicates', but if I do that it won't let me enter the date twice at all.

How should I manage this>
Thanks.

 

[PHV]

Use a composite key, ie a single index based on the two fields.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bhujanga]

I can't figure out how to get it to do that. If I select both fields, all of the property fields go away, right clicking doesn't bring anything up either. How do I do it?