>How can i populate a one-to-many form. I want to have one textbox for the user input and one grid for displaying the secondary records. This without using the dataenviroment, only with free tables. I'm having some troubles with the use of ChildOrder, LinkMaster and other grid related propertys.
Hector,
By saying displaying if you mean readonly then you could use SQL rowsourcetype provided your where clause only refers to indexed fields. ie :
thisform.myGrid.refresh
with this
.RowSourceType = 4
.RowSource = 'select * from myChild '+;
'where myField = trim(thisform.myTextbox.Value) '+;
'into cursor crsDispGrid'
endwith
If myField is not indexed you get a blank grid.
Cetin