Search results for query: *

Thanks guys, This is all useful information. I understand what you are saying Remou and you're right. I'm ok with step 1 and 4 of your suggestion, but not sure how to go about steps 2 and 3?? lridlen

Hi Remou, Thanks for being so patient with me!!! I understand what you're saying. Currently my report is based on the commission table, in your example above I should add an Invoice table and the report should build off this invoice table? If this is the case, how do I make a new invoice...

Hi Remou, sorry about the continued thread. This is the first time I have used this and not sure how to make a new thread and us both still follow it.... anyway, assigning the relationship to the commission table would give me a new invoice number for each commission entry and that's not what...

Hi Remou, sorry about the continued thread. This is the first time I have used this and not sure how to make a new thread and us both still follow it.... anyway, assigning the relationship to the commission table would give me a new invoice number for each commission entry and that's not what...

Thanks for your reply Remou. This is a very simple database with two tables - a Dealer table and a commission table. All that is recorded is the commissions each dealer would make in a month. There are currently 4 dealers. The report needs to show all the commissions sorted by each dealer...

Hi guys, I have also been trying to do something similar to this for a couple of days! The difference is that I don't want to have to choose the start number each time, i want the next_invoice number to update each time so that the next time I run the report it will start from the latest...