>I'm using VFP3 for Mac & Windows (which I upgrade to WFP5 to run on WinNT) as the client for Oracle tables on a server. I have been unable to get my one-to-many forms to run. The VFP documentation is too vague to provide a solution. What do I need to do?
There are a few ways to do it. The simple is to set a view parameter on the child file using the related field to the parent table. Whenever you change the parent record, requery the child table... sort of like...
Parent View...
v_parent
Child View...
v_child
in the filter put...
v_child.parentid == v_parent.id
*********************
All that is left to do is requery the child view when you want to get the child records for the parent record.
BOb
PS: Of course this is not specific to Oracle, but to remote views.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only