I have a Table 1 which has a list of all of our clothing inventory and columns that have attributes of those items (such as size, colour, fabric, etc). I have a Table 2 which has a list of our customers and their attributes regarding their preference...

I have a table [Table 1] which has a list of all the items of clothing stock that we have. I also have a table which is an events log [Table 2] of all the events that happen to those items of clothing (e.g. purchased, packed, posted, returned, etc) a...