Starting from the beginning I want one of the databases to:
Generate one database of records
Which has two automated serial numbers;
first serial number I am going to call the "account id"
second serial number I am going to call the "ref id"
I have three layouts;
first layout is the "master" this details all the fields and is designed to search all the records in the database.
From the "master" there are two script buttons taking you to the "add account" & "Update account" layouts
The "add account" layout is design to generate a new "account id" and "ref id" from here you edit all the fields to create a new record with a new "account id" & "ref id"
The "Update account" Layout is design to generate a new "ref id" but keep the "account id" from here you can edit set fields and create a new record with a new "ref id" but keeping the same "account id"
This is so I can then search and populate other layouts and databases to show all the "ref id's" associated to the "account id" but keep all the records in the same database.
If you can help then superb.