Grid - Display selected fields from 2nd Table 1

[Menglish]

I have two tables linked by custnum. On a form I show (table 1) Customer No., address, etc. I have a grid displaying table 2. The table has about 30 fields and I want to select 7 to display. If I do not issue "thisform.Grid1.recordsource='2'" then the grid does not display. If I issue the command above, then ALL fields are placed in the grid. In the grid properties, I have the columncount at 7 and the text buttoms have the selected field name. Can anyone tell me what I am doing wrong.

Thanks for any assistance.

--Millard

 

[Mike Gagnon]

Millard.

If you have a grid where at design-time you have not specified the recordsource or the columncount, the grid will show you the "current alias" with all the fields that are in that alias. Your grid needs for you to complete the design portion of it, use the grid builder and specify which columns you want to see etc...

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Menglish]

Thanks very much Mike, that fixed it.
-- Millard