September 3, 200520 yr Just a small problem, im trying to make an invoice (report). Two tables, related by a 'client ID'. One table contains the invoice items and the other the clients. When generating an invoice for a client im a bit confused as to how to only show the info for that client in the report, ive tried using a sub summary part by client ID, and then using related values from invoice, but although it shows the correct information it only shows one record, anybody want to point me in the right direction please? Cheers for any help, genx
September 3, 200520 yr Go to the related record and make it there instead via a GTRR(SO) ...with 7 can you tunnel values from the primary side of the relationship. It's only a matter of layout the right way. --sd
September 4, 200520 yr Yes, the GTRR will work from the selected record, which better be the client to whom the invoice is made for. --sd
Create an account or sign in to comment