I have started a new access desktop database project for tracking production in our printing department. I have a main table with general production data. I have an hour table that will keep track of all employee hours and rates. I also have a supplies table that will track supply cost.
I had originally tried putting all fields in one table but there are too many fields to track to do this.
I am have a great deal of difficulty linking both the hours and Supplies table to the main table at the same time.
I hope point me in the correct direction.