Datagrid SQL Relations LookUp/Column

[paulgenga]

I have found this problem.
Is it possible to lookup column from a related table by using an expression on the dataset design?.

 

[SqueakinSweep]

Not quite sure what you are asking, maybe you could give us more information. It is however possible to add relationships between datatables in a dataset, through code, using dataset.relations.add.



Sweep
...if it works dont f*** with it

 

[paulgenga]

I am trying to find the right expression to use in order to display the value read from a related table. On my dataset subselect, dlookup dont seem to work.
Please advice.

 

[chrissie1]

so you have a dataset with two tables and they are related and you want to select those rows from table2 that are equal to the corresponding row in table1?

Christiaan Baes
Belgium

"My new site" - Me

 

[paulgenga]

That is exactly what i mean, I couldn't describe it better

P. Genga
Kenya

 

[paulgenga]

I have just browsed and bookmarked your new site.
I think it looks perfect.

 

[paulgenga]

Select link on a datagrid column to display table2 values on other columns and leave updateable.