On Oct 26, 2006, at 11:23 PM, Greg Lindstrom wrote:
Can anyone point me to examples of creating/using forms with queries
containing joins? For example, I am building a client database
application
where I would like to display the client information from name,
address,
contact information tables where the latter two tables are joined
to the
first using and id field.
I'd then need to create an insert/update dialog that can populate
multiple
tables. I assume that it will consist of three insert (or update)
queries
where I insert a new name and get the newly created id, then insert
the
address and contact data using the id from the name table.
Paul recently discussed this very technique; see <http://leafe.com/
archives/showMsg/328009> for his comments.
His post will only answer the first part of your question, though.
If you need to update the data in 3 tables, then you should have 3
bizobjs. You won't have to do joins in your queries in this case;
instead, you set the bizobjs up to reflect the relations between
them, and when you requery the main bizobj, the child bizobjs will
update to reflect the related data.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
