Help for a wedding list structure

[kiteboarderni]

Hey there, the structure I have chosen is as follows:

Product table:

Id (primary key)
Name
Desc.
Color
etc

Wedding list table:

List Id (primary)
Groom name
bride name
Date of wedding

How ever i am unsure of the link table i will need to create between the 2. And also how to get the form design so that when i create a new wedding list that i can select multiple instances of products from within the wedding list that i have just created!

Thanks for any help, it will be much appreciated!

 

[boblarson]

Perhaps you might want to look at these data models already created:

http://www.databaseanswers.org/data_models/weddings/index.htm

http://www.databaseanswers.org/data_models/wedding_parties/index.htm

 

[HiTechCoach]

Hey there, the structure I have chosen is as follows:

Product table:

Id (primary key)
Name
Desc.
Color
etc

Wedding list table:

List Id (primary)
Groom name
bride name
Date of wedding

How ever i am unsure of the link table i will need to create between the 2. And also how to get the form design so that when i create a new wedding list that i can select multiple instances of products from within the wedding list that i have just created!

Thanks for any help, it will be much appreciated!

What version of Access?

This might help: The Wedding Planner

And these data models

Model 1

Model 2

 

[kiteboarderni]

Its access 2010! thanks

 

[HiTechCoach]

Its access 2010! thanks

Great! You will be able to use the Access 2007 Wedding Planner template!

 

[kiteboarderni]

Ive loaded it up there, seems very complex for what i need to do, ive just created the table structure advised for me from the other thread.

When i create the form in the wizard how can i incorporate the product table into the wedding list info within the same form, a subform i guess.

Thanks

 

[HiTechCoach]

Ive loaded it up there, seems very complex for what i need to do, ive just created the table structure advised for me from the other thread.

When i create the form in the wizard how can i incorporate the product table into the wedding list info within the same form, a subform i guess.

Thanks

To what weddng list are you referring?


If you are wanting to relate the products lsi to the wedding party (bride/groom) then you will need to have at least third juction table if not more.


It almost soudsn like you need to create a transaction similar to an invpice with a hedaer and detail lines lininbg a Wedding/Briode/Gromm (sutomer) to a list on products (invoice deatil lines).


What exactly are you trying to do?

 

[PNGBill]

Ive loaded it up there, seems very complex for what i need to do, ive just created the table structure advised for me from the other thread.

When i create the form in the wizard how can i incorporate the product table into the wedding list info within the same form, a subform i guess.

Thanks

As mentioned on my post in the earlier thread.

One table will hold the Couples Data - CouplesTable or use two, BridesTable and GroomesTable.

Another Table will hold the Wedding Details - Update from my earlier post. Call this WeddingHeaderTable.
Use this to hold the Fields from the one or two Couples Tables. The date of the Wedding, Venue, Budget etc.

Another Table can be the WeddingDetailsTable which will hold additional details - you should know what possible items are here but I guess Tasks to perform will be the theme.
Fields will be: WeddingDetailID, WeddingHeaderID etc. No need to include couples as they link through via the Wedding DetailsTable.

Last of the main tables is the ProductsTable and this will list the Presents?? and again be linked to the WeddingHeaderTable. or, is the products table actually the WeddingDetails issue??
This is where only you will know what you want to achieve.

When you do your relationships there is only one line from Couples/bride, Groome to WeddingHeader - one to many and one line from WeddingDetails to WeddingHeader, one header to many details and if Products then one wedding header to many products.

You may well end up with a few more tables but the main ones will be the Three to five above.

How do you enter data?

A use the wizard and make a form from the Couples Table and this will allow you to add Couples.

Another form from the weddingheadertable will allow you to add a New wedding event and in this form you can have the details.

You could have the wedding event as a subform of the couples form so when you add a couple you can go straight into their wedding header.

While this is quite straight forward if it is new to you it will take a little review and study to get it right.

Look at some templates and see how it is done and then ask specific questions on solving an issue.