On Jun 12, 2006, at 6:50 AM, Simen Haugen wrote:
This is what I'm looking for, yes. I want to be able to show one main
table (and also just update that), but that table should be populated
with values from other tables. I have one table of task types with
names, and a main table using just integer identifiers to link to the
names.
I also want to be able to change the type of task in the main table.
That is - I need to fill a choice list from one table into a column in
the main table - and when I update the table, the integer
identifier of
the choice should be saved.
I can also modify the tables if this is difficult to do using dabo.
(I'm no sql expert, so my database design might be a broken design)
You don't need to modify your database design; this is a perfectly
good normalized design. Did you see the wiki page I created to answer
this?
<http://dabodev.com/wiki/HowToPopulateAndUseListControls>
Let me know if that page helps, or if you still have questions.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
