What I'm not seeing in your post is exactly how your setup fails. Where does this setup go wrong? Voucher numbers don't show up for any records? Can't perform a find that locates all records where VoucherNum is blank? or...?
Even if I do a re-lookup on the invoice number in VendorStmt, no vouchers appear. I have verified that there are some that are paid. But even those do not show the voucher number indicating a paid invoice. I am stumped. Phil I do appreciate your quick response.
I wouldn't use a looked up value setting just to see the voucher numbers--that works, but it's needless complication and puts two copies of your data, the voucher number, in two different tables.
You'll need to check your relationships and the data used to match records.
- Check data types, make sure the fields on both sides of the relationship are the same type.
- If you have text fields involved, check for minor invisibile differences to see if something like a space character in one table's match field is keeping the values from being an exact match to the data in the related table.
To see the voucher number, I'd just add the voucher number field from the related table occurrence to your layout. If there's a match, you'll see the number. If there isn't, you won't and no relookup's will be required. To find records that don't have a voucher number in the related field, enter find mode, enter a lone * in the field, select the omit option and perform the find.