multiple item relationship for "specials" item

[happyshotdogs]

Ok, BIG newbie.

 

I'm trying to wrap my mind around how to have an item made up of a combination of items, ie: (hot dog + drink + chips; chips + drink; breakfast burrito + drink; etc...or even Hot Dog + Hot Dog + Chips + Drink)

 

What I have are tables with the item categories (easy to keep straight "to me"), such as Hot Dogs, Toppings, Drinks, etc...so I could have a table Specials that would have a line item made up of the combinations.  Hope this is making some sense.

 

This is what I have so far (just making tables that make sense "to me" at this point...any advice is appreciated)

 

I'll just attach my starting point db. (EDIT: says I'm not permitted to upload this kind of file...filename.fmp12)

PDF attached instead.

 

 

Also, I wondered how to have a conditional calculation for this scenario:

 

I have multiple hot dog toppings that can be added for one price (.50), but still want the toppings as seperate items.

To get a cost per item evaluation at the end of a day; cost of each condiment/retail price is needed to track----so, if customer gets coney sauce, cheese, and onions for example, but customer price is same for ANY/ALL toppings...

 

Clarify:

 

-customer 1

Hot Dog

 -coney sauce (.50 to customer), but get (cost to us)

 

-customer 2

Hot Dog

 -coney sauce        

 -onion                       (.50 to customer), but get (cost to us)

 -stadium mustard   /

 

-customer 3

Hot Dog

 -saurkraut  

 -cheese        

 -onions           (.50 to customer...and a quick need to get to a restroom ), but get (cost to us)

 -jalapenos     /

 -pickles       /

 

Again, I appreciate any insights!

 

Thanks!

HHD Menu.pdf

[Pavlk]

I hope that is what you meant.

 

Let me know if I got it wrong.

HotDogs.fmp12.zip

[happyshotdogs]

Thanks for the file, Paavo...now I'll see how to incorporate it into the 'big picture'