relationship/query problems

  • Thread starter Thread starter lane55
  • Start date Start date
L

lane55

I have two tables one holds primary material information.
Second holds scheduling information. Pieces of wood. Wood
is received in lots. Lot 1 may have 50 pieces, 8ft long,
12"x12", oak. Fields are lot number, amount received,
length, size and type. We split these lots into smaller
lots and make them into many diffrent types of small wooden
objects. I would take 5 pieces from lot 1 and schedule them
to be made into blocks. I can schedule to this point. I now
want to track how many blocks were created from each part ,
how many were miscut, how many had knots and were thrown
away etc. I am struggling with how to display all
information from table 1 and table two and add to it. I can
create a query that does display all info for the two
tables and a new third table with miscut,knots, poor
quality etc. But I can't add any new information to third
table. I am struggling to understand how to creat a single
form and display information from 3 tables and be able to
add information. Know if any good Demo bases that would
give me a clue what to do? Obviously I DON'T have a clue.
Thanks
 
Sometimes you just need to step back and take a walk. Went
back to my Access bible and worked out a solution. Thanks
to all who took the time to read my post.
 
Back
Top