Hi Richard. I have a follow-up question to my previous question and your answer from 12/30/09. I think I can understand/figure out the requerying that you were talking about (I purchased and watched all of the relevant lessons, I think). But I am stumped on trying to figure out how to have the tables work if only some of my items have sizes. For example:

Item, Price, Size
Tape Player, $4.99, no sizes
Jacket, Small, $3.99
Jacket, Medium, $4.99
Jacket, Large, $5.99
Radio, $5.99, no sizes

Where do I put the sizes to avoid redundancy? Basically, I am trying to create a purchase order system for my inventory, but don't understand how to set it up when only some items have the size attribute, and then knowing where/how to pull the price when I create the Order Detail continuous form for line items to put in the OrderF. Do I need to set up a query or something to pull all that together?

I hope this makes sense!

Thank you so much.

---

Reply from Richard Rost:

I'd need to know more about how you want to set your tables up. For example, if you just want to display the sizes that are available, just make a text box that will contain "S,M,L,XL". However, if you want to have different prices for different sizes, for example, then you would either need a second (sub) table, OR just make multiple entries for each size.