Hello All,
I am busy putting together a database to track WIP. We have a system whereby a customer places an order for a product. The order may be for various products and various qty's. We then open a job card for each product and this job card will indicate the qty of that specific product. We then need to break this down further into what we call heat slips, because each product is treated in the manufacturing process as an individual entity. We do this becuase our customers require us to have a serial number for each product (which we call a heat number).
I would like to put togther a system whereby I can, on one form, select a customer from a combo box. once selected I would like to have a datasheet table (on the same form) that allows me to enter a new order and the relvant details specific to the order i.e. date, order number etc. When I select and order from this drid the process must repeat (again on the same form, but on a datasheet gride below the order grid that displays the job cards against that order or allows me to enter w new job card. Similarly I would like a third grid, below the job card grid showing all heat slips, or allows me to enter a new one.
Is this a feasible layout and approach or does anyone have a better suggestion. I think I have the table structure and relationships the way they need to be, but am battling to get the table layout the way I want it.
I am attachcing a PDF file with two pages to show the tables and relationships and a sketch of the form I have in mind.
If anyone can give me some advice or a good resource to help me find a solution to this problem, I would really appreciate it.
Thanks in advance
Rob.