I am trying to create a metrhod of automatin record creation.

I am writing a database to run ticketing within a company and i need to be able to add a batch of records to a table at one time.

The TicketID field is a serial and i can set the next serial number and carry out a loop which creates the tickest however i want to be able to automatically populate the WardenID and Site ID fields of the new records.

I have created a table which has fields

WardenID - The warden to be issuing the tickets.

SiteID - The site the tickets have been issued to

TicketStartNo - The start number of the ticket batch

Quantity - Quantity of tickets to be created

A script then creates the records i a table called tickets however i cannot seem to pass the WardenID and SiteID

Please Please Please HELP!!!

It would appear to me that the WardenID would be the Warden presently using the database, so the trick will be get this from Filemaker. If the user requires a passname/word to get on the system, you could use this as a start. If you have a table of wardens with their passnames, you could use a relationship to get the WardenID. Site ID sounds like where they are when the database is opened, you could use the machine name to get to SiteID.

HTH and Hope I don't get ticketed by the Warden

Are these fields entered manually before the script is run?

WardenID

SiteID

TicketStartNo

Quantity

If so you can make globals of each and set them in the loop. Or you can create the first one and duplicate instead of creating a new record