July 21, 200421 yr Newbies 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
July 21, 200421 yr 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
Create an account or sign in to comment