3 types of clients - Need 1 report. Need Help

[stann]

Hello Everyone

We have a car auction here and we have three types of clients who pay differently. We need to give them a check but we have to take out there service charges. We have a field called paycode which simply has an entry of A , B or C in it. The Clients with "A" paycode Pay all there fees out of the first check ( most people have 2 or more checks for the number of cars they sell) -

the Clients with the paycode B pay the service charges from each check

and the Clients with the paycode C have nothing taken out because they need to be separately invoiced.

The fields here are Client AmountofCheck Paycode

So there are three types.

Can this be done so I can print out a subsummary report with the info intact?

Thanks

Stan

[Lee Smith]

Hi Stann,

As I stated to you off list, the client "A", is the hardest. I've played around with this a little, and can't seem to get my head around it. Separating out the charges associated with several vehicle (transactions), and then collecting them with the first check is a bugger. It was helpful to know that this all happens in one day. I was thinking maybe a script for finding the data, pasting it into the first check and removing the it from the others, but I've not have played with that concept yet, but it does seem logical.

I'm posting this simple file so that maybe other can help us out.

Lee

ForStann.fp5.zip

[-Queue-]

Here's the modified file with a Client_Date relationship and calculation to determine which is the first check of the day for type 'A' clients. I left the auto-enter serial for client ID, although it should be changed.

ForStann.zip

[Lee Smith]

Nice work JT.

Thanks for helping out on this.

Lee