Conditional create record, with find button.

January 24, 200619 yr

I need a script that will either go to a related record, or create a new record if no related record exists.

The application is a job that has 3 componets, I need 3 buttons 1 for each component that will be "goto / create" buttons. For the details held in each of the component tables.

Can someone suggest a script to do this?

Thanks

Daniel

January 24, 200619 yr

.. im a bit confused... but for the if no related record create new... (im assuming you want to create it in the original table and go back to the original layout...)

SetErrorCapture (On)

Goto Related Record (bla bla bla bla)

If (GetLastError) = 0

GotoLayout (Back to original layout)

Else

Create New Record / Request

End If

January 24, 200619 yr

Author

I am in table 1 - I want to go to the related record in table 2, if it exists, if not I want to create a record in table 2 that is related to the record in table 1.

Table 1 holds some initial details about a booking, with the rest being filled in table2. The will only ever be one related record in table 2 for one record in table 1.

Initially to create the record I set a veriable to the ID in table1 , went to table 2 and set the field to that value, hence creating a related record. I set that field to have to be unique, to prevent two booking records being created.

I then had another button, to go to table2 nd search on the ID from table1. ie "goto booking". It would be nice to place the functionality in one button.

Thanks for the script I will give it a go!

January 24, 200619 yr

Author

ok, see the logic, but I can't work out how to input the "If (GetLastError) = 0" part of the script. If I select If in the calculation field i get "The specified table cannot be found"

help!