Hi All,
I'm using my upcoming wedding as an opportunity to learn about using Access to build databases.
The source of my confusion is how to track the dietary requirements. I've had guests filling out free text field forms on the internet that tell me if they
- need milk for the baby
- no pork
- wheat intolerance
- fish (but not meat) etc...
Que: Should I create a new table (maybe called "dietNeeds") to represent this data then link this also to the adults &/kids OR should I make this free text data part of the already created tables?
Thanks for your willingness to help.
I'm using my upcoming wedding as an opportunity to learn about using Access to build databases.
- I've a table of RSVP'd wedding guests and their e-mails
- A table of the children names, ages and a lookup field (linking kids to parents in the above RSVP guest table)
The source of my confusion is how to track the dietary requirements. I've had guests filling out free text field forms on the internet that tell me if they
- need milk for the baby
- no pork
- wheat intolerance
- fish (but not meat) etc...
Que: Should I create a new table (maybe called "dietNeeds") to represent this data then link this also to the adults &/kids OR should I make this free text data part of the already created tables?
Thanks for your willingness to help.