In other programs I use I can add "groups" or "relationships" that can help me figure out which of my contacts belong to specific organizations (this could be another table, right? for each organization, one to many) but also who knows whom, who's related to whom... which become strings.... Do I do this with drop down lists, repeatable fields (like Apple address book)?

is there a way to map these relationships? tia

Greetings,

There are a couple approaches to this problem. This thread does a pretty good job of covering them:

http://fmforums.com/forum/showtopic.php?tid/171427/