On Aug 9, 2010, at 12:17 PM, Chris C. wrote:
> I'm actually trying to create screens to modify objects' attributes when
> those attributes are spread out in multiple tables. I was thinking that I'd
> use a sql query to gather all the attributes of one object, but I don't see
> where to put the query or how to create a screen to use it. And maybe
> that's not even the right direction, I'm not sure.
Keep in mind that AppWizard is designed for the most common cases, like
single-table maintenance apps. If you're pulling data from several tables into
a single form, you're probably going to have to do some custom coding.
The general rule of thumb is one bizobj per table, since bizobjs can
only write back to a single table. You can pull lookup values from multiple
tables into a single bizobj, but those will be read-only.
Without knowing how your tables/bizobjs are related (1:M, 1:1, M:M), I
can't give you any more info as to what you need to do to keep the bizobjs in
sync.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
