Thank you for reading, any help is greatly appreciated!

I have a Form called "Help Desk" and a subform called "Comments Log".

The Help Desk Form has a field named "[Work Order No]" with Data Type "AutoNum" and it's also a Primary Key. The field is used to assign a Work Order No to a record.

The subform has the following fields; [Date], [Summary], and [Comments]. These fields sometime require more than one entry to a record (Work Order No).

In order to perform function above, MS Access required Indexing to be "Yes(Duplicate Ok)" to [Work Order No] in Help Desk Table and all fields in Comments Log Table. Did what was required but...

How can I resolve duplicate (data) [Work Order No], if there are more than one comment to a record?

Anyone has any suggestions or idea? Many thanks in advance. http://www.access-programmers.co.uk/ubb/smile.gif