Can someone give me advice on how to set his up….
I imagine it’s pretty easy for someone who understands database structure.
I’m making a list for my daughters birthday party of things needed.
I want to make it where I can fill out one main list of items needed and then create a form that can be used to ask the same questions for each main item. I’d like to be able to show when all the items needed on second form is complete.
Here’s an example:
I know for the party I’ll need food. So, I create a main list of:(FORM A)
1. Dinner
2. Snacks
3. Drinks
4. Dessert
For each of the items, I’d like to be able ask:
(FORM B)
1. Name:
2. Items Needed
3. Special Notes:
For 1.Dinner
Form answers:
1.Pizza
2.10 Pizzas
3. Kilo Is allergic to mushrooms
For 2.Snacks
Form Answers
1. Potato Chips
2. 1 Bag of Doritos
2 Bags of Ruffles
3. No one likes Barbque
I’d like to be able to mark in someway when I’ve completed each item in FORM A.
I’d like to be able to add items to FORM A if needed.
Can someone show me how to do this?
Thanks in advance!
Thanks!
Yvette
Hi Yvette,
You could think about it in a bigger picture sort of way. Here’s what you could do.
1. Create a Events form that contains the event name, date of the event, location of the event, etc.
2. Create an Event Items form that contains item name, item type (e.g. snack, dinner, accessory (like balloons, etc.)), Price, and a Completed checkmark field.
2. Add a Link to Form field to your Events form that links to the Event Items form. Make it a “Many to Many” Link Type because you will want to use the same Event Items for different Events.
So now you have a nice form that lets you manage all the things you need for any kind of event.
Hope that helps!
Brendan
.
