Abki, please forgive me, but i don't understand your answer. Maybe because
i'm a beginner in Access. I don't know how to join tables nor to manually
writte a select. Maybe you get a picture for what i want to do, from my other
answer to Gina Whipp. Thank you too.

Abki wrote:
I hope u need data for all tables.

1) You can go thru all tables and data with 1 loop if you do join all tables
in 1 singel select.

2) If the select is manually written it can be like this:
SELECT *
FROM YEAR,
PLANT,
GENERATOR
WHERE PLANT.FK = YEAR PK
AND GENERATOR FK = PLANT.PK

PK = Primary key, FK = foriegn key
You will have 1 row for each unik kombination.

"dsasorin" skrev:

Hi !

[quoted text clipped - 42 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1