Create new record within a record

[delbert]

I have an invoice system that I am trying to create for a receipt for customers. On this receipt (invoice) I have multiple line items from which I select from a value list. When I select a Category in the value list and all of the related information appears, I want to create another line item on that invoice.

I am looking for a script that will create another line item that will not repeat the previous line item data. Does anyone have a sample script? Or, can someone e-mail me with the script or post it here?

I guess basically that I am trying to create a new record within a record.

Thanks in advance!

Delbert

[Fitch]

The best way to set this up is with a separate Line Items file, where each record is a line of an invoice. In your Invoices file, make a Relationship to the Line Items file based on Invoice Number, and make sure it's set to allow creation of related records. Now make a portal on your invoice file and put the fields from line items in it. You can still use your value lists as before.