jump to specific table

[John_L_tD]

L.S.

Im busy for my graduationto fill a database with sevaral tables
, from there to perform technical calculations.

each table belongs to a specific "group".

if I, by using a query enter data, I want to "jump" to a specific
cooresponding table within the database, from wher I select de desired
fileds, for furter calculations

f.i.
Project table consists several data as f.i project number etc. but also
"Pressure" "Size" "Temperature" "Material" .

if I, by using a query, enter project data I want to "jump" to a
corresponding table
where f.i. "Pressure" as value is part of the tablename , and then from that
table select data where "Size" field corresponds with the "size" which is
entered in the query of the project table

how can I "Jump" to specific table where I select a part af the tablename?

hopefully some one can help me on this on

(excuses, for probably bad English, its not my natural language...)
thanks in advance
John

 

[Dale Fye]

John,

It sounds like what you need to do is merge all of these tables. You should
not have distinct tables for each project, but instead, should have a single
table and a ProjectID field, so that all of your queries, forms, and reports
are based on this single table, and all you have to do is refine the query
for that form or report based on the ProjectID.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.