Hey all,
Our local accountency software prints reports out with as source a DBF file.
Now for a long time it looked a bit like this
Product | Discription | amount | Price | Total Price|
123456 cardridge 12 2 5€ 10€
789101 cardridge 13 1 5€ 5€
The info of what the custumer ordered was in that dbf with 1 record for every product (a product per line)
Now they patched the software so it is able to show if the amount of products the customer ordered are also in stock, but in stead of adding a extra kolum in the dbf file they did it with a extra record line.
Product | Discription | amount | Price | Total Price|
123456 cardridge 12 2 5€ 10€
"amount on stock 2"
789101 cardridge 13 1 5€ 5€
where the amount on stock 2 is a single field of characters
they did make a record type field so it is possible to see if the record is a real order line or a information line
with a simple
IF record type = 48 Then right ({discriptionField},2)
i can filter out the amount of articles reserved already and place it under the mount colum.
Problem is that i would rather see that 2 in a extra colum next to the amount colum and drop the extra record like :
Product | Discription | amount | reserved | Price | Total Price|
123456 cardridge 12 2 2 5€ 10€
789101 cardridge 13 1 0 5€ 5€
and add a zero in case nothing is reserved for that customer.
I'm looking for a way to use a field from the next record so that i can make it look a lot better as how it looks now.
Tnx for the feedback !!
Adam
IP Logged
