See properties LinkMaster and RelationalExpr. You can change these properties in the standard grid builder. Perhaps you have to change ChildOrder too - I'm not sure right now.
A view will give you some advantages, though: specifically, you can create temp indices to sort data, for instance, when the user clicks or double-clicks on a grid header. This isn't possible with the relationship mentioned above, since it depends, precisely, on an index.
HTH, Hilmar.
>Hi everyone....
>
>It is early morning here and I am tired... and really flustered now... lol...
>
>I have form with a simple DE of two tables: order, and notice. In the DE is set the relation notice.orderno into order. At the top of half of the form is an order display (orderno, date, custno, etc.)
>
>I want a grid at the bottom to display all of the related notices sent out... shouldn't the grid, which has a datasource of 'notice' by default only allow display of relation records??? I move from one order record to the next and I see the notice table moving along; but I can see other none relation records in there as well... so, am I to have to create a view/cursor for such a simple task?? or am I wwwaaaayyyy overdue for bed and missing something basic???
>
>laughing at myself...
>
>Ric
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)