You need to refresh the grid. Your set relation is causing a similar effect a SET FILTER TO does. Or do you have the relation backward? Are you wanting TableB limited to the current record in TableA? Why are you even relating TableA if your not moving the record pointer from From2?
HTH, Tracy On Wed, September 2, 2009 8:14 pm, Sytze de Boer wrote: > Hi Foxers > > After the telling off from Mr Ted Roche, I'm not sure if I want to ask > another question, but I'll try > > Amongst others, there are 2 free standing tables (Table A and Table B > I have a form with a grid that displays TableA > I click a command button that now display products in TableB > > The init on this form has "set relation to code into tableA" > All is well until I release this 2nd form and return to display TableA > > I make sure I "set rela to" and Select TableA > There is only 1 record showing in TableA > > Is there something else I should do ? > > -- > Regards > Sytze de Boer > Kiss Systems > Hamilton, NZ > Ph: 64-7-8391670, Mob:021 937611, > www.kiss.co.nz > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

