MattCass87
New member
- Local time
- Today, 15:00
- Joined
- Sep 4, 2017
- Messages
- 8
Hi all,
Please see below and attached. I’m creating a ordering system where employees can login and create an order. The order will also consider stock and eventually also work out costs.
When an order is raised, that order can then be made up of many parts. So ‘order 1’ could have ‘part 1’, ‘part 2’, ‘part 3’ all created on different days and with many different components.
Orders = List of parts
Parts = list of components
Components would be combinations of materials with sizes and quantities.
Component1: Qty: 10 Size: 1000x1000 Printer: Machine 1 Material: Vinyl 1 Material: Laminate 1 Finishing: Cutter 1 Packaging: Package 1
I would appreciate some feedback on the plan below, does the structure make sense? Or is it illogical?
This is quite a big task for me having not touched access for about 10 years so I want to make sure im on the right path before I start.
Thanks in advance for any advice
Please see below and attached. I’m creating a ordering system where employees can login and create an order. The order will also consider stock and eventually also work out costs.
When an order is raised, that order can then be made up of many parts. So ‘order 1’ could have ‘part 1’, ‘part 2’, ‘part 3’ all created on different days and with many different components.
Orders = List of parts
Parts = list of components
Components would be combinations of materials with sizes and quantities.
Component1: Qty: 10 Size: 1000x1000 Printer: Machine 1 Material: Vinyl 1 Material: Laminate 1 Finishing: Cutter 1 Packaging: Package 1
I would appreciate some feedback on the plan below, does the structure make sense? Or is it illogical?
This is quite a big task for me having not touched access for about 10 years so I want to make sure im on the right path before I start.
Thanks in advance for any advice