Job/serial number verification between DBs

[ASD John]

I have a main DB where a sequential job/serial number is assigned every time a new record is created. This DB is related to three other DBs that each might use the job number field. Buttons are used to transfer data, including the job number, to any of the related DBs as necessary.

I do not want the Job number to be transferred more than once to each related DB. When a "transfer data" button is selected I would like a script to verify if the job number already exists in the selected DB. If it does exist, the user should be prompted of the match and kept in the main DB.

I'm a FMPro 6 user. Somewhat of a rookie too. Please help! Thx

[-Queue-]

If you have a relationship based on job number, test

If [not IsEmpty(relationship::serial)]

Show Custom Dialog ["This job already exists in the other file."]

Halt Script

End If

Then continue with your steps to add the new job number.