D
DS
I have a bit of a quandry with a table or tables as it may be.
The first table is called MenuDetails,
the fields are:
TerminalID
MenuID
PriceID
StartDay
StartTime
EndTime
AfterMidnite
Active
the 2nd table is called MenuDetails...this has quite a few fields
TerminalID
DayID
MenuID
PriceID
SectionID
ItemID
ItemPrice
ItemPrinter
ItemPrep
Group
GroupLevel1
GroupAction
ModID
ModPrice
ModPrinter
ModPrep
SubGroup
SubGroupLevel1
SubGroupAction
SubModID
SubModPrice
SubModPrinter
SubModPrep
The problem is that the first table only has another 4 fields than the
second table. Should I just can the idea of 2 tables? Will that be to
many fields? The other problem is that the last field SubModID, depends
on these fields because it can be different depending on whats in these
fields....TerminalID, MenuID, DayID, PriceID, SectionID, ItemID, Group,
ModID, SubGroup...
Any help appreciated.
Thanks
DS
The first table is called MenuDetails,
the fields are:
TerminalID
MenuID
PriceID
StartDay
StartTime
EndTime
AfterMidnite
Active
the 2nd table is called MenuDetails...this has quite a few fields
TerminalID
DayID
MenuID
PriceID
SectionID
ItemID
ItemPrice
ItemPrinter
ItemPrep
Group
GroupLevel1
GroupAction
ModID
ModPrice
ModPrinter
ModPrep
SubGroup
SubGroupLevel1
SubGroupAction
SubModID
SubModPrice
SubModPrinter
SubModPrep
The problem is that the first table only has another 4 fields than the
second table. Should I just can the idea of 2 tables? Will that be to
many fields? The other problem is that the last field SubModID, depends
on these fields because it can be different depending on whats in these
fields....TerminalID, MenuID, DayID, PriceID, SectionID, ItemID, Group,
ModID, SubGroup...
Any help appreciated.
Thanks
DS