Dear Experts!
I have a database used to store production data for several processing areas (each area collects data). The database is set-up so that each area has its own table and one table stores the lot data that is common to all areas.
I am trying to create a report so that I can see all lots and the last step that they were processed at (so I can see how lots are moving thru the production line). I tried to create a report that has (4) fields from the common table (which is linked to all other tables), and then (1) field from the additional (14) separate process area tables (that one field I want from the other tables is the "Date Completed" field). I go through the entire process and at the end a pop-up dialog box appears with the following: "Wizard is Unable to create your report."
It doesn't even tell me why the wizard failed. I've checked my relationships between all the tables, but don't have any other ideas as to what may be wrong. Does anyone have any ideas?
Thanks!
I have a database used to store production data for several processing areas (each area collects data). The database is set-up so that each area has its own table and one table stores the lot data that is common to all areas.
I am trying to create a report so that I can see all lots and the last step that they were processed at (so I can see how lots are moving thru the production line). I tried to create a report that has (4) fields from the common table (which is linked to all other tables), and then (1) field from the additional (14) separate process area tables (that one field I want from the other tables is the "Date Completed" field). I go through the entire process and at the end a pop-up dialog box appears with the following: "Wizard is Unable to create your report."
It doesn't even tell me why the wizard failed. I've checked my relationships between all the tables, but don't have any other ideas as to what may be wrong. Does anyone have any ideas?
Thanks!
