Check Boxes

[nitinkedia]

HI

I am trying to develop a solution to streamline my contacts.

Apart from other contact information like phone numbers, email etc, I want to have a feature which allows me to see to which category(ies) the person falls under.

An example of the categories is "Supplier", "Buyer" ,"Consultant", "Doctor", "Personal Friend", "Relative", "Key Customer", "Competition" etc.

A person could belong to one or more category,therefore I want to select the categories by using check boxes.

At the moment I can think of only these categories but I know that gradually I will have a lot more categories and thus cannot limit myself to only these categories.

Is there any way that a check box field appears for any new category that I add......you know somewhat like the way it happens in MS Outlook.

Looking forwward to an early reply.

Thanks

Nitin

 

[shay]

Hi

You could display the categories in a datasheet subform. Instead of having loads of check boxes, place a combo box containing all your categories on the subform then for each contact you can select as many as required.

Put all your categories in a table and base the combo on it - this way the form will automatically display all categories (including any new ones!)

hth

shay