So i have learned alot using Access in the past few weeks. i may not know all the in and outs of creating codes, but i have a good understanding of the design. I want to make sure that i am going down the right path with this DB.
I am aware that repeating data is a no-no.
Task: Create a report that shows inventory items (broken down into category's) entered for each specific Job Number. I want the Job number information as the title (ie. job number, project manager, date created, etc). All of this information is already stored into a table.
"Jobs"tbl w/ Fields