> From: Paul McNett <[EMAIL PROTECTED]>
> Sounds like DOW is derived from orders.date. I'd use VirtualFields for
> this.
> pkm ~ http://paulmcnett.com

Looks like I gave a faulty analogy. Sorry to waste your time.
The correct analogy:
PCG: Order-LineItem-Part

Fields:
Order - orderpk, name
LineItem - lineitempk, orderfk, quantity, partfk
Part - partpk, package, typefk & joined with Type - typepk, description

I joined Part & Type (and a few others in my design) because they're
all read-only in this application.

I have a dTextBox with DataSource="LineItem" and DataField="partfk"
I have two text boxes with DataSource="Part" and datafields "package"
and "description", respectively.
If I change the partfk field, save and requery, the "package" and
"description" fields change appropriately. What is the proper way to
update them without requerying the whole Form? Or should I just
manipulate the display boxes manually from a cursor?

Thank you,
Cory Cross

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users

Reply via email to