How do I automatically create parent record?

[Michael Herrinton]

I have two related tables --

1. Invoice Header

2. Invoice Line Items.

The key field connecting these two tables is Invoice Number.

When I import invoice line items records into the Invoice Line Items table, how can I automatically create parent records (with just invoice number recorded) in the Invoice Header table? (Of course, there will be one record in the Invoice Header table for each invoice number).

Thanks.

[RalphL]

Where are importing the line items from? You haven't given us much to work with.

You could make a value list from the Invoice Number in the Line Item table and use the ValueListItems to make a list of Invoice Numbers. Use this list to create records in the Invoice Header table by a script.

I assume this would be a one time thing.