The way it’s gonna work is like this:
Two tables. One table deals with the items, and the other deals with the prices.
In the item database, each item will get one row in the database. The row will include item title, description, and price field.
The title will be one field, the description will be one field, and the price will be a link to another table which has all the prices listed. So each item can have multiple prices.
In the price database, for each item, there will be a sorting/priority field to allow for some sort of intended order of all the prices. The price table/rows will consist of a sorting/priority field, a description field and a price.
The “Item” table will also have a field which states wether an item is current or not. NOTHING will get deleated. Also in the “Item” table, a “Date Created” field will keep track of when the item was created.
The menu on the left will be created (in the Spa Services menu) by pooling the “Item” table, looking at what items are current and listing them. A third table “categories” will designate the different services. It will also drive the top menu system.There needs to be a way to separate “Wellbeing, Body care and Skin care”.. more thought required.
When editing the “Item” table, allow for images to be added in the description. Images to be shown on the right side of the screen, and have the image displace the text.