Spa System

[Jessika]

I am new to Access and Ive created adatabase to control a spa system.
I have several tables: Customers
Employees
Types Of Haircut - Their prices
Types oF massage Their Prices

Now I want To create a form where i am able to choose customer, the employee performing the haircut or massage
The price should be displayed and the total AMount

How can I do that?
Should I create a Query and based on the query I create the form?

Please Help!!!

Thanking you all

 

[Rabbie]

How can I do that?
Should I create a Query and based on the query I create the form?

Please Help!!!

Thanking you all

Thats the best way to do it. Just make sure your query is getting the right data

 

[Pat Hartman]

You have too many tables and not enough tables, if that makes sense.
1. Employees can be customers so they belong in the same table. Use a field that contains their hire date to indicate that a person is an employee.
2. Although haircuts and massages are not interchangable, they are both services and again belong in the same table.
3. You are missing at least one table and that table can be called transactions. It is used to record the event of a person having a haircut or a massage. It is this table where you would record the service date an the PersonID of the employee performing the service and the PersonID of the customer receiving the service and the ServiceID of the service that was performed. If you want to capture more detail information such as start time and end time and perhaps a discount code for the times you don't charge full price and the actual price charged. This is the table that will be used to create your performance reports. Who did what to whom and how much did they spend.

 

[Zigzag]

Hi Jessika,

Start by setting out in your mind or on paper how you would like to select the customer.
The way i would do this would be creating an unbound form with a Combo box (customers table as the list).
Then create another form (Subform) based on a query...(The query would be base on the information you wish to see for each customer from your tables)
Put the Subform onto the main form and then go into the subform query and base it on having customers like the combo box(customers).
Break it down into a step by step sequence.
If you get stuck or need help just post back.