Info from 3 tables on the same form

[virgo]

I need to be able to scan information from 3 tables into 1 form. The tables all have a common field, idnumb. I tried to link the tables by id number. This only worked when I used the wizard.

I am pulling some of the information into text boxes and some into grids.

The scan does work. The big problem is that the tables don't scan at the same rate.
The grid control just pulls information, period.

I am trying to pull up all accounting information that related to one individual.

I would appreciate any help in this area.

 

[JDurbin]

You need to set relations if you're doing what I think you are. Besides using a wizard you can also set relations from the data session window and then view the code generated in the command window. You didnt specify if its a parent to child or 1 to many or whatever. If you set relations and skip in the parent table the children will follow. John Durbin
john@johndurbin.com
MCP Visual FoxPro
ICQ VFP ActiveList #73897253

 

[TomasDill]

Hi!

The grid control just pulls information, period.

When you established one-to-many relationship, in grid you will see only one record for main table and asterisks for all child records of that main record.
However, strangely recommended to use SELECT-SQL command to select data from all three tables into single cursr and than show these data in grid. If you need to modify such joined data set, use view.


Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs