Feb 2 2004, 05:06 PM
I have a subform (that displays data from linked Foxpro tables) within a form that a user populates based on info from the subform. The primary key(field name is RMA number) is NOT set to autonumber so there are duplicate records with the same RMA number. When data is entered into the form, the data is duplicated for each record that has the same RMA number. There is a field (serial number) that is unique. How can I filter the data RMAnumber/serial number so it will only populate the record the has the unique serial number?