G
Guest
Hello.
I am in the process of setting up a simple contacts
database. It will have the usual fields (eg Name, Tel.#,
etc.) However, I also need to set it up so that it tracks
if the contact is the member certain group(s)that the
inputter can check off.
Name Tel.# Group 1 Group 2 Group 3
-------------------------------------------
John 555-1212 x x
Frank 555-3232 x x
Mike 555-6535 x x
I want to do this with check boxes. How would I set up
the tables structure to accomplish this? I thought about
just having one table called "Members" that would contain
all the fields but I know this will cause me problems in
the long run. Shouldn't I have a table for Members and a
seperate table for Groups? If so, how would this look and
how would the form be designed so that they can be checked
off?
Any assistance would be appreciated.
Thanks in advance,
m.
I am in the process of setting up a simple contacts
database. It will have the usual fields (eg Name, Tel.#,
etc.) However, I also need to set it up so that it tracks
if the contact is the member certain group(s)that the
inputter can check off.
Name Tel.# Group 1 Group 2 Group 3
-------------------------------------------
John 555-1212 x x
Frank 555-3232 x x
Mike 555-6535 x x
I want to do this with check boxes. How would I set up
the tables structure to accomplish this? I thought about
just having one table called "Members" that would contain
all the fields but I know this will cause me problems in
the long run. Shouldn't I have a table for Members and a
seperate table for Groups? If so, how would this look and
how would the form be designed so that they can be checked
off?
Any assistance would be appreciated.
Thanks in advance,
m.