Multiple records from one entry

[gadgetgirlfriday]

Basically, I am trying to create a punch list for portions of a job that still needs to be completed. The fields I need are -

Date

Notes

Item 1

Item 2

Item 3

Item… the number of items will change depending on the job. But there will be a setup layout to input all Items before records are created.

I would like to use check boxes or radio buttons for Items

If 3 items have the same date & notes I need to create 3 separate records with one commit button. How can I do this?

I hope this makes sense.

Thanks in advance

[efen]

Are the items the same for every job or unique for each job?

...and welcome to the forum

Edited February 23, 2010 by Guest
welcome added

[David McQueen]

Setup your original data entry in global fields. From reading what youhave, the items appear to be pre determined, but which ones are in each job is not known.

Once all parameters are set up in the global fields, then have a script that checks each item. If it is not empty or does not say "No", a record is created and filled from the globals.

It has the additional advantage that nothing is committed until you run the script.

HTH

Dave

[gadgetgirlfriday]

Thanks for responding.

Efen - yes, the items will be unique for each job.

David McQueen - I think I understand. I will give it a try today. I appreciate your help! :content: