DateExpress

Hi All,

I am trying to pupulate a combo box..emm best I give an example..

Table1

ItemID

ItemName

SaleID

Table2

SaleTypeID

Description

My default dataset looks up table 1....like this...

SELECT Table1.ItemID, Table1.ItemName, Table1.SaleID

FROM Table1;

this isnt much use since the sale ID is just a number I want it to lookup table2.Description....so..

SELECT Table1.ItemID, Table1.ItemName, Table2.Description

FROM Table1, Table2

WHERE Table1.SaleID like Table2.SaleTypeID;

This will work (ignore any silly sql errors)...but I would prefer the combo box to have all the descriptions from Table2, thus allowing the user to select a meanfull description......but

if I do this how do I update the database.....ie

if a user changes the sale offer, I cannot send the description back but must send the ID back.

cheers

Baz

[958 byte] By [Bazza99a] at [2007-10-2 6:03:42]