Iam sorry Helen for not making myself clear ... What I mean by
automatic fill data is this ... Try to imagine this scenario ...

In my product table I have the itemID, itemName, ItemUnit,
ItemExpireDate
... my invoicedetails table I have invoiceID, itemID, itemName,
ItemUnit, ItemExpireDate, QtyOrder.


What Iam trying to say is if in TIB_lookupcombo I have choosen a
particular item, that corresponding ItemName, ItemUnit,
ItemExpireDate in the invoicedetails table will be filled up. these
column really exists in the database They are not lookupresult
column...