MS-Access How can I join the product table and product sizes

[joseph6640]

I have a database for restaurant management systems containing products table -the products have many sizes and prices like pizza have three sizes and three prices i need help to join the product to their sizes and price

 

[plog]

Can you show us your table structure? Need table names, field names, types, and some sample data.

And what are you ultimately trying to do? What are you going to do with this one its joined?

 

[The_Doc_Man]

There are many schools of thought on this question. The SIMPLEST answer is that your product isn't Pizza. It is Large Pizza or Medium Pizza or Small Pizza.

However, there is ALSO the possibility that you put the size qualifier in the price table, so your product is Pizza and the price entry CONTAINS the word Large, Medium, or Small.