Look up Google for the party entity relationships diagram or schema. A "party" is either a "person" or a "organisation" (company, org) The party is an entity ( table) that has an id. The org or person tables have a foreign key to the party id. It is a mutual exclusive relationship. A party must never be both.
Through the party id you have access to org and person. The party interacts through a role and relationship table. So party "Smith" with the role "employee" is employed by employer party "My company Ltd." with the role "employer". If you need the "role" entity is something you must decide. But the relationship table is essential. Any relationship can be created with this many-to-many table. These are starting steps... ) Roland _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode