>Yes. I see, thank you. Now here's my next question if you could be so kind. I understand that you can't have duplicate records, but I thought you could do this: the index is on ProductName+RevisionNumber. In other words, I have a record for each product in a 'main' table. if there is a change to the product, it's Revision Number is incremented and a new record is added. Therefore, if you browsed for a particular product, you might see:
>ProductABC - Revision 0, ProductABC - Revision 1, ProductABC - Revision 2
>so, there are (in this example) three records where the product name is duplicated, but the Revision number is different. If I create an index on both fields, it still gives the "Uniqueness " error. Is there a better way to do what I'm trying to do? I have Product General information and submit, review, and approval dates in the 'main' file, and it works with three other tables that contain Technical information, Component or Formula information, and Material Safety Data Information....follow me?
Yes I think I do. First off, the Primary key in the table, if I understand, should be something like:
Product + Revision
Where Product and revision are the field names. If you get a uniqueness error, then you should look for the offending records as I described in the first email. If you need clarification on the syntax, write back with the actual table and field names.
Oct 31 = Dec 25