Hello everybody,
I am designing a company database right now and need to validate something.
I've got tables:
- Orders
- Deliveries
- Products
- Product Details
Now, what I need to do... In the Products table, there will be all product types, with their name, parameters, picture, dimensions etc. But I need to track every single product by its serial number (servicing, being able to look at the S/N and tell when it was delivered, who ordered it etc.).
Hence, the Product Details table will have a foreign key to a record in the Products table, its serial number, buying price (connected to a Delivery) and a selling price (connected to an Order).
I also need to have a form for creating orders, along with adding multiple products (with their serial numbers).
Am I doing it correctly or would you recommend a different approach?
Thank you very much!
Thomas