I have a db which has multiple tables which are all linked via a unique number

When I create a new record in the contact layout and then want to go a second layout which contains data from another table I cant get into that layout useing the script GTRR as there is no related record in this table. How do I set it so when I create a new record in one table it creates a record in all the tables?

Kirsty

Are you saying that all you tables are related with a one to one relationship? Most relationships are one to many and new records on the many side are created as they are needed. Why do you want to go to the related record when it has no data?

If you could post a sample of you database it would help us understand what you are trying to do.

You could script that, e.g. using EventScript, so that when you create a new record the other records are created. Usually, though, we use portals to create new records.

If you have 'Allow creation of related records' enabled for a particular child table, you can use Set Field [relationship::datafield; datafield], where datafield is NOT the key field. This will force a related record to be created and the key to be established. Then you can make your child fields lookups to the parent table to have them auto-filled or simply put the related fields on the child layout if you want them to update automatically when fields in the parent record are modified.