Open mouth, insert foot. Yes, yes, yes. I added an additional expression variable and a condition on the detail line where carrier invoice number = .vinvoice and carrier code = .vcarcode and it works!
Thanks for helping me see this in the right context! Have a nice day. Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of claudine robbins Sent: Wednesday, July 21, 2004 2:42 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Lookup dilemna Aye, aye, aye, I can't do that, there might be several differenct carriers with the same iex invoice number.... Remember, the first break is iex invoice number. The line containing iex invoice number X03-1000 should not even be looked at... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Johansen Sent: Wednesday, July 21, 2004 2:08 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Lookup dilemna Claudine, We sometimes have the same problem. If 2 carriers are going to have the same invoice id, then I think you are going to be more specific in your where clause i.e. PRINT INV_DETAIL WHERE INVNBR = 'X04-1431' AND CARRIER = .vCARRIER OPTION PRINTER. I'm pretty sure that RBase always takes the first instance. Jan ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 21, 2004 12:00 PM Subject: [RBG7-L] - Lookup dilemna I have a report (invoice_detail) based on table carrier_invoices. Carrier_invoices table has two records as follows: Date carrier carrier invoice iex invnbr amount 01/01/03 ABC 20488 X03-1000 $500 07/20/04 DEF 20488 X04-1431 $1000 I am printing invoice X04-1431 The print command is PRINT INV_DETAIL WHERE INVNBR = 'X04-1431' OPTION PRINTER. The first break is on the iex invnbr, the second on the carrier invoice number. Date is correct - 7/20/04 Carrier name is correct - DEF Carrier invoice number is correct - 20488 IEX invoice number is correct - X04-1431 Amount is incorrect - It prints $500 instead of $1000 I simply renamed the first carrier invoice number in order to print the correct amount but am wondering what's wrong with this scenario... It simply is unavoidable that different carriers might have identical invoice numbers... Claudine :)
