Can someone please help me with this, I have two tables that I want to create scrap collection for 2 parts. I want to make form that would have date which would be same for both parts since I'm checking for scrap same date for 2 parts. I want to have same reasons for two parts for scrap. Here is example of form I would like:
Date: 1/1/01
Reason for scrap Part1(text Label) Part2(text label)
Large Dia. Oversize 25 18
Large Dia. Undersize 12 36
Small Dia. Oversize 0 5
Small Dia. Undersize 9 11
I would like to enter date on forms and input number of scrap pieces for each part. Can someone tell me how to create tables (or do I need one table?) and create form to enter information for each part.
Date: 1/1/01
Reason for scrap Part1(text Label) Part2(text label)
Large Dia. Oversize 25 18
Large Dia. Undersize 12 36
Small Dia. Oversize 0 5
Small Dia. Undersize 9 11
I would like to enter date on forms and input number of scrap pieces for each part. Can someone tell me how to create tables (or do I need one table?) and create form to enter information for each part.
