Help with easy script :(

[Jota]

Hi... i have a database with aprox 40 fields... is a sales databases. This databases have 2 big parts: The client information and the product information. Every register is a new sale.

The problem: When a old client buy a product, i must enter your personal data again. I make a button that clone the register, but when a i clone all the data is copied... i need copy just some fields (for example the name, phone number, street, etc... but i don

[TSC]

You can use the duplicate record feature and then clear the fields you want to not copy.

The best way is to re-design the db. A contact database, a line items and a invoice database. The invoice database would relate to the other two files