Using check boxes

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top