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