I wasn't sure where to post this.
I have a rather sticky (to me) problem.
I have a database of prize winners... the prize winners are often not repeated.
However, sometimes they are. The current database is just an excel spreadsheet in Acccess so I'm rebuilding it.
My thought was to Have a Person Table which would have first name, last name, address, phone, email...
And a prize table with prizewon, datewon, contestwonfrom and collected
(these aren't the actual names, I haven't gotten that far yet hehe)
The problem I'm having is I don't want to assign user id's to people becaue they may never come back... but we do have a fair bit of people that win every few months.
I was going to make a 'name' field and just have the entire name and use that as the matching criteria for person - > prize. However, in looking t hrough some samples I've noted that people always use fldFirstName and fldLastname - never something like fldName (which would bef irst and last)
Long explanation for a simple question - do I really need to break up the name? Or can I just use one field for the entire thing?
Thank you =)
I have a rather sticky (to me) problem.
I have a database of prize winners... the prize winners are often not repeated.
However, sometimes they are. The current database is just an excel spreadsheet in Acccess so I'm rebuilding it.
My thought was to Have a Person Table which would have first name, last name, address, phone, email...
And a prize table with prizewon, datewon, contestwonfrom and collected
(these aren't the actual names, I haven't gotten that far yet hehe)
The problem I'm having is I don't want to assign user id's to people becaue they may never come back... but we do have a fair bit of people that win every few months.
I was going to make a 'name' field and just have the entire name and use that as the matching criteria for person - > prize. However, in looking t hrough some samples I've noted that people always use fldFirstName and fldLastname - never something like fldName (which would bef irst and last)
Long explanation for a simple question - do I really need to break up the name? Or can I just use one field for the entire thing?
Thank you =)