Jump to content

Create new record within a record


This topic is 7171 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7171 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.