Okay, another question from the Newbie.
I have a dataset called dsPOLookup which consists of two tables.
POHEADER and STATUS (they are linked by POHEADER.PO_STATUS and STATUS.STATUS_ID)
I have a dataview dvPOHeader which uses dsPOLookup.POHEADER as its' table.
I have a datagrid which uses dvPOHeader as its' DataSource
When I populate the datagrid, I want the Status column to contain the STATUS_DESC from the status table instead of displaying PO_STATUS from PO_HEADER.
Is this possible? Can a dataview contain more than one table? If so, how? I am using the properties dialog to set these values, perhaps I have to write some code?!
Please let me know if you can help.
THanks and Regards,