Best way to create a 3 deep master/child Access form

How do I create a 3 deep master/child form?

Background:
I haven't used Access for years, I am using Windows 10 and Access 2016.  I have a new small business making paper flower bouquets.

What I want to achieve:
Create a form that displays Product(bouquets) info, listing the product items(flowers) and paper items(paper used in creating the flowers).  I want to be able to add Flowers (from tblFlowers) to the Product(The flower info can be read only) and add Paper items to the flowers, need to be able to edit and save that.  

1 Product to many Flowers
1 Flower to many Paper Items

My Question:
What do I have to do to create this 3 deep master/child form?  (I will look into the "how to do it" if someone can get me started by guiding me with what I need to do.)  There seem to be many ways to achieve this and I don't know which is most suitable to my needs and (rusty!) knowledge.

Hope it makes sense,
Thank you :)
Marie FlouryAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eric ShermanConnect With a Mentor Accountant/DeveloperCommented:
If you are using Access 2001 or later ... you should be able to create Nested Subforms or a subform within a subform.

Create subFrmFlower with the FlowerID as the Parent field linked to the FlowerID field in the Paper Items table.  Next create your main form frmProduct with the ProductID as the Parent field linked to the ProductID on the subform subFrmFlower.  Use a Combo Box to navigate the main form and move the record pointer accordingly.

ET
0
 
Marie FlouryAuthor Commented:
Hi Eric,

Thank you for your help.  I have followed the steps and it is working :) The only problem I have is that I need to see a list of all the flowers that are part of a product at once (don't want to click on "next record" buttons to see them one by one).  Is there a way to show the flowers in a listbox and when I select one it shows the paper items?
0
 
Marie FlouryAuthor Commented:
Hello again!  I have worked out how to do it... I created a query to populate the list box and linked that to the subform.

Thank you for your help :)
0
 
Eric ShermanAccountant/DeveloperCommented:
Ok, thanks for the points ...  Also, you could use Data Sheet views for your Sub Forms.

ET
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.