I need to combine 11 tables into one on their common index. This of course will require an addition of fields to the combined table. I have tried both asking the query to add and by addings fields to the Combined table "T00AllCat" to no avail. I always get the same "___"record(s) due to validation rule violations.
What is the simplest way to accomplish this simple task?
The data base attached contains Tables T01 through T11, plus my effort to make a combination table; "T00AllCat", "T00AllCatCopy", and "T00Base". The query I have been trying to use has been multiple versions of "QAppT00AllCat_T01" .
Any and all guidance will be greatly appreciated.