Hello,
I was wondering if anyone would be willing to share any insight into how to set up a form where a user enters in the names of attendees during a meeting.
Right now, I have it set up as separate fields for each attendant. Therefore, there are twenty attendant fields named [Attendant1], [Attendant2] .... [Attendant20]. I believe this structure would be fine if the only purpose were to store the data. However, I can foresee issues once I want to recall specific meetings by searching for individual attendants since any attendant could have been entered into the attendant1-20 fields.
Long story short, I am asking if there is a better way to setup the fields or if there would be an easy way to create a search form for when I want to search by attendant. I am thinking that if I keep it in the structure I have, then I would end up using union queries and then perhaps losing the integrity of my data.
Thanks for any feedback!