Invidivuals vs Organizations

[jacque_56]

I have a table of foundation contributors that consists both of individuals and companies. The companies include names of contact persons. The table includes names, addresses, phone and email. This has a relationship to 'contributions' and 'groups' tables the contributions are populated by a form that pulls up the 'either' individual or contributor on a combo box.

When I set up the combo box, it wants to sort one field so up to this point I have been using putting the Last Name in the Organization Field if it's an individual. (last name is shown twice) Its a klutzy solution and I'm sure somebody out there has a better idea.

HELP.

 

[AncientOne]

What's in the Groups table?

Do some companies have more than one contributor?

 

[jacque_56]

More than one contributor?

No, I don't think so.

The Names Table consists of lists of all that have ever contributed. I don't think there are any instances where the same company is listed with more than one contact person.

Does that answer your question?

thank you for reading and trying