Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem using view in grid on 1:M form

Status
Not open for further replies.

tonedef

Programmer
May 24, 1999
64
US
If I use the 1 to many form wizard to create a form where the child grid source is a view the page works fine. The problem is I would like to put the grid on a page in a tabbed page frame so I don't want to use the wizard to build the form. When I do this I have a problem since the view doesn't have an index. (I think that is where the problem is anyway). Somehow the wizard must create a local index for the view to be used properly as the source for the grid. The problem is I don't know where the code is to accomplish this so I can "hack" it into my form. If anyone has a solution or knows where I can find the code that the wizard generates it would be greatly appreciated.

Thanks,

tone
 
On my system, this is where the code for the wizards are:
D:\Microsoft Visual FoxPro7.0\Tools\xsource\xsource.zip
 
Views can not have indexes. to get the child to show parent key records use "set filter to" on key value. I put the set filter command on the page activate event, then refresh the grid.

You could always do a pramitized query where keyfield = value, then reset the grid recordsource, and refresh. Attitude is Everything
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top