I have a form which shows data from a detail table linked to a master table.
The link is via a master index created from one field in the master but the
detail table also has this field for linking but cannot easily have a master
index as the records in this table are not unique and Paradox tables require
the master index to be unique. The best example of my problem I can think
of would be a form which shows an invoice line item records. The invoice
table being the master table which stores the invoice info with the detail
table storing the line item detail. But what if the user has two identical
line items so there are two records in the detail table with the same Part
No. Then I do not have unique records and get a key violation error. I
have tried introducing another field called say LineNo to give the table a
unique multi field index but in my application I need to allow the user to
insert lines at will. There lies the problem. I have had a lot of trouble
in trying to re-sequence the LineNo fields on a record insert. Sorry for
the long winded explanation. Do I need the line item field. How do I
re-sequence them on an insert. Does anyone have any guidance to offer.