Junction Table and Table issue

[BartK]

Myrtle,
Thank you for your post, it does make more sense now that you phrase it that way, and it would definately clean up the DB as well. I didn't even think of it that way, and I will have to most definitely read up on the normalization of the tables. Thanks once again.

 

[EternalMyrtle]

No problem.

BTW, you might as well add a field called CheckInDate to your Checkout table to keep track of when equipment comes in.

By structuring the tables properly and normalizing them, you will have much more control over the data later on even if it seems counter-intuitive to do it this way. In particular, by checking out each item to each person individually in a separate record, you will be able to create more meaningful groupings of data.

 

[EternalMyrtle]

Equally important for grouping is putting the equipment into one field rather than 4+ separate fields. This way your reports will be easy to make since you can easily group by employee or equipment type and get meaningful results.

 

[BartK]

Myrtle,
I believe I have done the changes you proposed correctly. This may seem a little trivial to you, however this is the most "complex" DB that I have done, never done anything this elaborate. I've always just dealt with 1 table, at most 2 but with no interaction between the 2. Please look at new pic to see if I am anywhere close to what you are instructing. Thanks a million for everything.

 

[EternalMyrtle]

Looks great!

Yes, this can get incredibly complex especially when you start needed more functions, which means more tables, forms, subforms, queries, reports. Never mind code if that happens.

Now that you are on solid ground with your table structure you should be good to go.

Good luck with the rest of your project!

 

[EternalMyrtle]

Wait I noticed one problem: you need a primary key field (autonumber) for your junction table, so EmployeesEquipmentID or something

 

[BartK]

I would of been "throwning darts in the dark" thank you myrtle for your help and especially your patience.