I have a stores data base for a cadet unit. I have a table where I want to track what specific uniform parts are issued to a cadet.
StoresIssued(table)
Cadet last name
cadet first name
ShirtID#
PantsID#
Boots ID#
+5 other items
Each type of part has its own table
ShirtTable
ShirtID (Primary...