Cotswold
Well-known member
- Local time
- Today, 07:57
- Joined
- Dec 31, 2020
- Messages
- 1,035
Sigh. I don't normally repeat myself but after 43 posts none of us know anything at all. We don't know what data is to be stored. Nor do we know what information is required from the system.
As I have said, the system starts from the contents of the Tables, not from an airy fairy idea, or an imagined input screen. Write down the use for of each of the tables and the actual data in each table and how they relate. That should have been post #1. If your existing system is a dog's breakfast, copying it might not be a good idea.
Maybe take a step back? What you are doing has been done for thousands of years but maybe for different products. How would you do it 80, or 100 years ago? Probably with books of card indexes, or rolodexes. Stuff would arrive and be posted onto the cards. Sales would be deducted, then a ticket given to a typist to type the invoice and send it. Computers aren't necessary for a business but they should make it more efficient. Unfortunately that is not always the result. As is demonstrated by some of the rubbish we have to use on the internet.
As I have said, the system starts from the contents of the Tables, not from an airy fairy idea, or an imagined input screen. Write down the use for of each of the tables and the actual data in each table and how they relate. That should have been post #1. If your existing system is a dog's breakfast, copying it might not be a good idea.
Maybe take a step back? What you are doing has been done for thousands of years but maybe for different products. How would you do it 80, or 100 years ago? Probably with books of card indexes, or rolodexes. Stuff would arrive and be posted onto the cards. Sales would be deducted, then a ticket given to a typist to type the invoice and send it. Computers aren't necessary for a business but they should make it more efficient. Unfortunately that is not always the result. As is demonstrated by some of the rubbish we have to use on the internet.
Last edited:
