Data from different tables to a form

[pillaisg]

How to retrieve the data entered in different tables (4) to a form.There are instances where i need the display of some information entered in one table to display in different forms also. Can anybody guide how to do so.

Thanks
Pillai

 

[pbaldy]

One way would be a query that joined the 4 tables together. Another would be subforms.

 

[pillaisg]

Ya but can you just guide me with an example.

 

[stopher]

Ya but can you just guide me with an example.

I think you need to explain a lot more about what it is you are trying to do i.e. what information you are presenting, table names, field names etc and what youwant to do on your form e.g. data entry. This will help the contributors decide on the best solution to propose.
Chris

 

[pillaisg]

Linking different tables to one form, or different forms

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.