Good day guys!,
I have a table named cake_catalog and it has some data as follows-
5 columns cakeCatalogId,prod_code,size,flavor,price respectively:
81 100050 JUMBO BUTTERMOIST 2530.00
82 100050 JUMBO CHOCOMOIST 2530.00
83 100050 JUMBO MOCCA 2230.00
84 100050 JUMBO VANILLA 2230.00
85 100050 REGULAR BUTTERMOIST 1970.00
86 100050 REGULAR CHOCOMOIST 1970.00
87 100050 REGULAR MOCCA 1820.00
88 100050 REGULAR VANILLA 1820.00
I made cakeCatalogId,size,flavor,and price primary key because combinations of size and flavor has different price.
and i have a form that maintains these data,I can add lets say a new flavor of a certain product for the JUMBO size,edit a current price, or delete a size.
My question is how can i present/maintain these data effectively?
My plan(and its an ugly one) is to just show all the size,flavor, and price of the user's selected product one by one an just have a button if he wants to edit each.so in this certain product, It will show:
JUMBO BUTTERMOIST 2530.00 
UMBO CHOCOMOIST 2530.00 
JUMBO MOCCA 2230.00 
JUMBO VANILLA 2230.00 
REGULAR BUTTERMOIST 1970.00 
REGULAR CHOCOMOIST 1970.00 
REGULAR MOCCA 1820.00 
REGULAR VANILLA 1820.00 
Thats not good to look at I know because of the repetitions
So how can I do this right?
I will try any help you guys can give me
thanks in advance!
P.S.: I will proceed with my first "ugly" plan if I cant get another solution to this.