On Fri, 23 Feb 2007, Ken Dibble wrote: > In my application, I'm faced with many situations where I have to store > many-to-many data in link tables. In order for this to make sense to the > user, I'm going to have to "translate" the FKs in these link tables to > something meaningful both when displaying data and saving entries back to > the database. You know:
Ken, Don't know what dbms you're using, but at least SQLite and PostgreSQL support views. You can set up the view to show columns from multiple tables in a single virtual table. Postgres allows you to enter or edit data in the views, sqlite doesn't. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
