August 24, 200619 yr I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) , id, forign key. Checks Received (amount date) , id, forign key. both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that. thanks for your help, I know it is not easy question but Im sure there should be someone outthere who knows the solution. Yaron.
Create an account or sign in to comment