Auto-Duplicate A Record?

Hi!
If you have a lot of field, may be you should arrange them in the visual editor.
What kind of database do you use?
If MySql or Oralce or the same you can use db trigger to duplicate rows or data. So you don't have to edit the project just the database.
br.
Dennis

Hi,
I have a total of 30 columns and I do not want user when they add/edit, they will have to scroll all the way to find the field they want to add/edit as it will be too long and messy.
Thus, I used PHPRunner to create 4 menus as below:

1. Master (Only for viewing all the 30 columns, and the data is automatically created from "Menu A","Menu B","Menu C")-> Without user interaction
   
2. Menu A (Only contain 10 out of the 30 columns, and each record is unique based on the client name)-> User creation
   
3. Menu B (Only contain 10 out of the 30 columns, and each record is unique based on the client name)-> User creation
   
4. Menu C (Only contain 10 out of the 30 columns, but a same client name can have many records)-> User creation
   Steps:
   
5. User must create a new client name in Menu A first.
   
6. In Menu A, once user created a client name: ABC and its corresponding columns are filled in with data. User click save.
   
7. "Master" menu will automatically show the record created from Menu A. (First 10 columns out of the 30 columns)
   
8. In Menu B, user will fill in another 10 columns, 1 more column will be the client name (the client name will be in a drop down list whenever user created a new client in Menu A)
   
9. "Master" menu will now have 20 records (10 from Menu A and 10 from Menu B ) under the same client name.
   
10. In Menu C, user will create the last 10 records. However, for Menu C, under same client name, user can have many records.
    
11. In Menu C, user create 1 record with client name: ABC. "Master" menu will show all the 30 columns data from Menu A, Menu B, Menu C.
    I have done all the above steps, however I am facing problem on the following steps which need some kind help.
    
12. If user add another record with same client name: ABC in Menu C, in "Master" menu I need to have auto-duplicate all the record except the last 10 columns from Menu C is different. Is it possible?
    Thanks in advance the help.