TDBGrid.. need a column from another table! |
|
Hey gang
I am using a TDBGrid on one of my forms. It is using a datasource called
files. This has a dataset table that is linked to another table datasource
called accounts.
Now in the files table i have a column that is called file_type which is an
integer.
Yup, you've guessed it, i have another table called file_types that has a
file_type integer and a description that is a string. I need to display the
file type name in the DBGrid.
Now I know i can select / join using a query however in this situation I
need it to be done via datasource / tables as i need to be able to edit the
data for the files table using the DBGrid.
Help!!!
JC
|
Re: TDBGrid.. need a column from another table! |
|
Nevermind.. i got it using the fields editor and lookup!
Thanks anyway
JC
"Justin Case" wrote in message
news:710333@forums.embarcadero.com...
> Hey gang
>
> I am using a TDBGrid on one of my forms. It is using a datasource called
> files. This has a dataset table that is linked to another table datasource
> called accounts.
>
> Now in the files table i have a column that is called file_type which is
> an integer.
>
> Yup, you've guessed it, i have another table called file_types that has a
> file_type integer and a description that is a string. I need to display
> the file type name in the DBGrid.
>
> Now I know i can select / join using a query however in this situation I
> need it to be done via datasource / tables as i need to be able to edit
> the data for the files table using the DBGrid.
>
> Help!!!
>
> JC
|