Using another table as a criteria for a make table.

[KEVNDALE]

I have two tables.

One table gives values for E-1 (execution week - 1 week) E-2 (two weeks til execution) and so on all the way up to E-15. This is called Weeks table.

There is a simple action that updates that table every week with new values.

Second table creator takes user input for what date the E-0 starts on (from the Weeks table). Multiple weeks tables are created based on > E-1 and < E-2 and so on and so on but this is all derived from input from the user when running the make table.



I would like in the criteria for the make table for the various schedule weeks to automatically pull the E-1 column (example being 11/25/2012 11:00 pm) instead of having the user input that information in everytime and every week to make new tables.

Any help would be greatly appreciated.

[June7]

Having to continually create multiple similar tables indicates data structure is not optimized. Do you want to provide db for analysis? Follow instructions at bottom of my post.

[KEVNDALE]

The multiple tables are created to break down a work schedule into weeks.
E-1
E-2

and so on and so on... That way the schedule can be reviewed for that work week. The criteria is what breaks it down into seperate weeks.

[June7]

Still, constantly creating new tables indicates poor design. The conventional approach is a single table and then apply criteria to filter records. The criteria that 'breaks it down into seperate weeks' should be applied to filter a single table.