Duplicating records in form view

[Markand]

I have created a form which insets data into 5 seperate tables.
Is it possible to duplicate a record in form view rather than copy and paste the record in each of the 5 tables respectively.
Any suggestions gratefully received.

 

[trucktime]

Copy

Why would you put the same info in several tables? You may want to save time and space by storing info only once and use related tables instead.
Not sure what you are trying to accomplish though.

Trucktime

 

[Markand]

On the same form some data is customer related, and is therefore stored in the customer table, Some is product related and stored in the products table, order info is stored in the orders table. The information is not repeated, its is unique information input into a single form which sends the relevant info to it's respective table