Best way to create a 3 deep master/child Access form
Posted on 2016-10-24
How do I create a 3 deep master/child form?
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
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 :)