Forms & Subforms

[kid_viciouss]

Hi, i am designing a database for college and i'm not asking anybody to do my homework here.



I know how to make normal forms and i could easily learn how to make subforms. However, if i make forms for all my tables, do i need subforms? If i make normal forms for all my tables do i then add subforms to THEM forms or make them seperately? I don't understand how you would go about using them?

Should i have 4 normal forms for my tables or 4 subforms instead? Not exactly sure coud somebody direct me in the right direction. PLEASE

Thanks

[orange]

What is your database about?
What is the business your database is intended to support?
What is the purpose of your Form(s) and/or subform(s)? Who will use them? For what exactly?

In Access the Form/subform construct is often associated with tables that are relate in 1 to Many relationship.

[kid_viciouss]

What is your database about?
What is the business your database is intended to support?
What is the purpose of your Form(s) and/or subform(s)? Who will use them? For what exactly?

In Access the Form/subform construct is often associated with tables that are relate in 1 to Many relationship.

Hairdressing business.

Tables: Client, Appointment, Stylist and Treatment.

I have a main menu form with those four buttons.

I was going to make four normal forms but not sure if the subforms would be necessary. I have never used subforms before so not sure if they would be needed.

And they are one to many relationships.

Thanks

[orange]

There are free models at DatabaseAnswers.org that may give you a starting point.

Here are the business facts
Here is the related model

Good luck.