>I want to use combo list boxes with search criteria similar to an order and orderitems scenario and a command button to display the results in a grid for entries and editing. Should I use a local view for the contolsource of my grid? Assuming a small network is a local view sufficient?
Both a local view or the table itself would work. If you bind combo (rowsourcetype = fields) to parent and relate it to child (grid), selecting in combo would move rec pointer in parent and thus move in child. But you should avoid unnecessary refresh otherwise you wouldn't able to move to any record other than first in child. Plus if you would have more than one criteria setting is easier with a view. If you set the rowsourcetype of combo(s) to SQL then it would be better and you could populate the grid with a parameterized view than.
create sql view myorditemview as ;
select * from myorditems ;
where linktoparentkey = ?m.parpk ;
and opt1 = ?m.opt1 ;
and opt2 = ?m.opt2 ;
...
requery("myorditemview")
Cetin