Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parent-child form question
Message
From
08/03/2000 16:04:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Parent-child form question
Miscellaneous
Thread ID:
00343441
Message ID:
00343441
Views:
54
Help!

I am working on a parent child form which is used to make purchase orders. I use 2 views for this form(one I called purchase_order, the 2nd is purchase_item) They are related by a field I called po_no(automatic no)
When I make a new PO, I click on "Add" button, but the po_no(from parent part) does not show up until I have this code(on the buttonset)
*******
do case
case thisform.buttonset1.cmdadd.caption = "\ dodefault()
case thisform.buttonset1.cmdadd.caption = "\ if thisform.PO_NO_ID1.value = 0
=requery()
thisform.refresh()
dodefault()
else
dodefault()
endif
endcase
*******
I do "requery" to get the po_no which is needed for the child part. But my problem here is after I requery, the first record(on the parent part) always comes up on the screen. I just want to stay at the record I just add(from parent part), then I can add child records.
Any suggestions would be appreciated.
Thanks in advance.
Reply
Map
View

Click here to load this message in the networking platform