I've been tasked with building a new database to track our print operation. It must track multiple customers with multiple products each. For each edition I need to track up to 5 press runs production values. I also need to track supplies used and by far the largest part is tracking regular and overtime hours for each associate in each part of the operation. That means hours, rates, names, total regular and overtime cost. I started with one main table with everything in it but that didn't last long. I split my data into multiple tables and that helped. I need to be able to enter all this data on one form. I can't seem to figure out how I'm going to do that. I created a join query but there are still too many fields for one query. I'm attaching a copy of what I have so far and hopefully someone will be able to point me in the right direction. The names and pay rates in this database are all made up at this point, no real people or pay rates.