- Local time
- Today, 19:31
- Joined
- Feb 19, 2013
- Messages
- 17,470
yes, you can navigate to different orders using the buttons at the bottom of the main form. Note that I have not provided for properly adding new orders which would be determined based on how you want it to work - you may for example go via the customer form or have a switchboard, or another button on this form to set it up to add a new order.
Your table design is basically OK but you might want to consider splitting the customer table into several tables - for example address - you may invoice to one address but deliver to another, so you would keep the addresses in a separate table linked back to the customer record. Similarly you may have more than one contact per customer so again you would keep customer contacts and their email/phone details in a separate table.
Your table design is basically OK but you might want to consider splitting the customer table into several tables - for example address - you may invoice to one address but deliver to another, so you would keep the addresses in a separate table linked back to the customer record. Similarly you may have more than one contact per customer so again you would keep customer contacts and their email/phone details in a separate table.