Hi
I know this is not a direct firebird .net provider related question but
I didn't get an answer on the M$ newsgroups so will try here to, sorry. :)
Is there a way to create lookup columns in tables in the typed datasets?
Like
CityTable
----------
CityID
CityName
Employee
--------
EmployeeID
EmployeeName
City -> foreign key to CityTable.CityID
CityName -> lookup column, will get the value from CityTable according
the City value
First the CityTable records are loaded and then the Employee. I could do
this with SQL but that means I would load the same data 2 times and I'm
trying to lower the network usage as the lines that we are using are slow.
In expression column I was trying to use the Parent keyword but with no
luck. So is there a way to do this?
Also is there a way to create more of these lookup columns when a table
is related to more tables with foreign keys?
I used lookup fields with Delphis ClientDataSet.
I was trying with the expression column but i came up with somthing like:
Parent(FK_City_Employee).CityName
where FK_City_Employee is my relation in the typed dataset.
Unfortunatly according the help there is no such way, this only works
for the Child.
Is it possible to define a lookup column with the Expression property or
is there some other way to do this?
Thx
Zoltan
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
