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. Any help would be appreciated. I'd even be willing to write this up for the wiki. --greg --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
