December 21st, 2012, 11:47 AM
Delphi Database help (http://i48.tinypic.com/i1lnad.jpg)
I am currently working on a order database using Delphi, i want the two order ID (circled in red) to have the same order id, it should remain the same for as many items as the customer wants until a new customer , moves on when the next Id when there is a new customer.
i have uploaded a screenshot, and as i am not allowed to post links i have put it in the tittle .
December 24th, 2012, 06:40 AM
Adoorderline : I would use a Tadodataset with "Select * from Orderline were OrderNo=:OrderNo".
Adoorderline.Masterfields := 'OrderNo';
Adoorderline.IndexFieldNames := 'OrderNo';
December 28th, 2012, 08:36 AM
I got it to work before you replied, although my solution was slightly different i think .
Originally Posted by bummi