Grid not blank when user press New Invoice button

[mstrcmtr]

Setting Grid for Sale Invoice Detail Table

thisform.Grid1.LinkMaster = 'Header1'
thisform.Grid1.RecordSource = 'Detail1'
thisform.Grid1.RelationalExpr = 'Header1.KEY_PK'
thisform.Grid1.ChildOrder = 'Key_Fk'

---------------

SELECT Detail1

SET ORDER TO KEY_FK IN Detail1

---------------

SELECT Header1

SET ORDER TO KEY_PK
SET RELATION TO KEY_PK INTO Detail1
SET SKIP TO Detail1

------------------

Requirement:

Q. How can Blank the Grid (Child records) on Clicking New Invoice Command Button , currently it is showing all Child table records in Grid.

If both Parent child tables open in browse window when select the Header record it shows the relevant child records

 

[mstrcmtr]

Problem solved

Using thisform.Grid1.Refresh() instead of thisform.Refresh()

 

[Mike Lewis]

I'm pleased you've solved the problem, but I must say that your solution is surprising.

When a form is refreshed, all controls on the form are also refreshed.

So calling the Refresh for the form should also refresh the grid.

But if it works for you, that's fine.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads