I have a rather complicated question. I am pulling all records from the ITEMS table with VENDORNUM=1234. Each of these records will have the field SERFLAG=''. Also, each of these records will have data in the field VENDITEMNUM.
So, my select formula is "ITEMS.VENDORNUM=1234" and my report fields are: ITEMNUM, VENDORNUM, VENDITEMNUM, SERFLAG.
OK, now here comes the complicated part. Some, but not all, of these records will have a matching record in the same ITEMS table (matched on VENDITEMNUM) where SERFLAG='R' (the VENDORNUM field will be different as well). I need to print the ITEMNUM field for these records if and when they exist.
How can I do this.
So, my select formula is "ITEMS.VENDORNUM=1234" and my report fields are: ITEMNUM, VENDORNUM, VENDITEMNUM, SERFLAG.
OK, now here comes the complicated part. Some, but not all, of these records will have a matching record in the same ITEMS table (matched on VENDITEMNUM) where SERFLAG='R' (the VENDORNUM field will be different as well). I need to print the ITEMNUM field for these records if and when they exist.
How can I do this.