how do I write this script??

[Shelby]

Hello

I opened up a computer repair shop and created a filemaker database I really like using filemaker 8.5

My problem is simple to me but hard for me to figure out.

When a customer comes in that has been there before I would like to do a search by either their last name or phone number and if either is found then create a new record using there pre existing information ( address )

thats it

I have be creating a new record with their last name then doing a find and copying the information between records. I know this isn't hard but I cannot figure it out

Please help me

Ronald

[bcooney]

The new record that you wish to create is, perhaps, a repair ticket?

I would find in my Customer table, and have a button on the customer form that creates a new repair ticket. The script would capture the customerID into $custID, switch to by Repairs table, new record, set field __kF_CustID to $custID.

I could provide more detail if I knew your table structure. I am assuming two tables, Customers and Repairs.