I'm having a mental block when it comes to config packages and lookups.
I have a package with both table 18 (Customer) and 222 (Ship-to-Addresses). If I populate both with both the customer number and address code, both throw the error that the record can't find the matched record in the other table.
I received the recommendation to drop the address code out of the customer table, import the two tables, and then do another pass taking in just the customer number and address code in the customer table. I think I must have misunderstood, because I am back to having an error for every record in both tables. I'm wondering if I validated too much, or used the validate in the wrong place (header instead of line).
Can anyone offer a reference or help me understand the sequence?