Cartesian Product
Well... if you really want to use a Cartesian product (i.e. all possible choices from all the tables)... That's pretty easily done.
Just make a select query with the tables in question but don't link the tables together, go to the SQL tab and click it. When you see the SQL code... just after "SELECT" put in the word "DISTINCT" (This will ensure you get only one record for each iteration), and then run the query.
--------------------------------------------------
Then, if that result is really what you are looking for, you can turn that query into a static table (which might be easier to use than a query with no links) by taking your select query and turning it into a “make table query” and running it... You’ll have to update (i.e. rerun) that query every time the data changes, but you can get your code to do that.
Anyway…
I've done things like this all the time with small amounts of data where I needed to link up the fields and show zero or null categories for crosstabs, or when I need all the 15 minute intervals for every day of the month laid out…
-------------------------------------------
Honestly, I didn’t read the thread thoroughly enough to figure out exactly what you are trying to do… but its sounds like that's what you want.
Normalized data is nice and all... but sometimes getting it done now is more important that appeasing the database administrator’s sensibilities lol
HTH
Gary