Linking tables with form

[pillaisg]

I am having 4 tables where i enter all the data required. The tables are Project Details, Process Detail, Installation Detail & Cable Details.
Project Detail Table containsroject Number,Project Code,wBS Code etc...
Process Detail Table Contains : Tag Number, Description, Service, Process values etc...
INstallation Details Table contains : Installaion Item, (nearly 40 items which are commonly used)
Cable Details Table Contains : Cable Number, Type of Cable, Size of Cable and so on
Now I need the form: Process detail containing the information which had been entered in Project detail also. Such as the Project Number, Code etc to appear in the form ( Just to display it)
In Cable Detail and INstallation forms I need some specific fields which are in Project details (project Number, Code..), Process Details ( The tag numbers, Description etc..) to appear as display.
The tag number shall be the primary key which shall be used in all forms except Project detail form. The information in Project details is just to appear in the report.
I could very well do it when all this information was in one table. As a beginer i am unable to solve this. So please guide me.

 

[neileg]

Depending on how the data is related, you could:
1) Join the tables together in a query and base your form on the query
2) Use a form/subform setup to handles the tables (though it is good practice to base forms on a query anyway even if the query is based on only one table)