Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help for Micros 3700 geting structure for Item - Modifier group - have those modifiers

Status
Not open for further replies.

IvanTasin

Programmer
Jan 24, 2020
3
RS
So i make a console application in c# and make odb connection on micros 3700 database. With tool Sybase Central i figure out most everything but i miss this..
Need this QUERY for this kind of structure:

Item_2
Modifier group_1
modifier_1
modifier_2
modifier_3
Modifier group_2
modifier_1
modifier_2
modifier_3
Item_2
....
So what i need is; My item BURGER have modifiers (requeired or not requeired) and they are in some modifier group.
I need 1,2,3 sql for this and key how to bond that because now what i saw in mi_def i have modifiers but don't know the bond betwean Item-Burger(example) and (mit, rare, medium) modifier - in some group.

PLS HELP .. This is first of many questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top