Linking data

[mojo1979]

Hi,

I have an HR database which has 5 tables and 5 forms. One of these tables is the main table with name, salary etc in, with an accompanying form. The other tables include employee review etc, again with an accompanying form. What I need is that when a particular person is selected on one of the other forms (not the main one) that info from the main table is automatically shown on specified fields.

How do I do this? Using Relationships?

Thanks in advance,

Frustrated Access User

 

[Remou]

Are these other forms subforms of 'stand alone' forms and if so, does the main form remain open while all this is happening?

Subforms are usually the easiest way to have several forms relying on one another.

 

[mojo1979]

Well, the main form would be closed, and these forms would just need to pull the data from the main table

 

[Remou]

It may be possible to use queries for the other forms (queries are generally recommended):

[tt]RecordSource: Select MainTable.ID, MainTable.Surname,OtherTable.Hours From OtherTable INNER JOIN MainTable On OtherTable.MainID=MainTable.ID[/tt]

Or DlookUp:

[tt]=DlookUp("Surname","MainTable","ID=" & MainID[/tt]

Or, as mentioned before, subforms.

It all depends on how the other tables and the main tables are set up. Have your read

http://www.r937.com/relational.html,

for example?