>Dear Borislav,
>
>Thanks for Your speedy replay can you be more specfic with some (Example of Coding)
>
>With Regards,
>
>T.D.Muruganandam
With pleasure, but I don't know how you organise your form. I suppose you have a several controls that are binded to this table. If so you must use a view to do this and issue TABLEUPDATE() when you want to save the changes. But the select must be:
m.lcMedcineName = Bill.Medicinename
SELECT * FROM Stock WHERE Medicinename == m.lcMedcineName INTO CURSOR lcStock
You must also have an Index based to Medicinename so the query to be rushmore optimized.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.