Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many form
Message
From
07/10/1998 02:11:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
One to many form
Miscellaneous
Thread ID:
00144461
Message ID:
00144461
Views:
72
I need to design order history enquiry form. In the form, it need to inquiry three tables information (Order, Order-item, Delivery-Detail). Each order can have many order-item, and each order-item can also have many delivery detail. I just want to how to create this enquiry form. In this form, it with contain two grids. One is to display the order-item, and the other one is display the delivery-detail. Orderno is the key to seek the order-item, and the orderno, item-no and item-color are the key to seek the delivery-item records.
I also want to know how to set the childorder, linkmaster, relationexpr in this two grids (grid-orderitem, grid-deliveryitem).
Waiting for any suggestion.

Thanks

Dennis
Next
Reply
Map
View

Click here to load this message in the networking platform