Claudine If I'm understanding you right then I would think you need a view that sums up the amount grouped by carrier invoice number. Then do a lookup in the view whe carrier invoice number = carrier invoice number.
Buddy -----Original Message----- From: claudine robbins [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 3:48 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Lookup dilemna I have three breakpoints: iex invoice number (X04-1431 in this case), the Carrier Code (DEF in this case) and the carrier invoice number (20488 in this case). There are no variables to reset, the detail line is directly from the Carrier_invoices table. It's crossing over and picking the amount from the wrong record. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Wednesday, July 21, 2004 2:17 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Lookup dilemna Claudine Are you resetting the amount variable on Invoice Number or the iex Number. I would think you want to reset the amount vaiable only when the invoice number changes and not the iex number. Buddy -----Original Message----- From: Claudine Robbins [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 3:00 PM To: RBG7-L Mailing List 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 :)
