> I may have missed the first part of this discussion, but it would seem the
> easiest thing would be a unified contact list, with some extra logical fields
> for roles:
> Vendor T/F
> Customer T/F
> Employee T/F
> Prospect T/F
> etc, to control who is on what dropdown list.
Actually the model would look something like this (shortened to keep it
easy):
contacts
--------------------------------------------------------------------------
contact_id, first_name, last_name, role_id references role(id)
role
---------------------
role_id, description
1 | Vendor
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
