Linking tables

[newtoAccess]

I have two tables.



I have a separate data entry form for both of the tables.

How do I get some information to be automatically displayed on the form when the user is inputting data?

Example: If the user enters a name of a team, the league and group should be automatically displayed in the next fields. The data would be coming from the other table?
So how do I link tables together?

[ajetrumpet]

I have two tables.

I have a separate data entry form for both of the tables.

How do I get some information to be automatically displayed on the form when the user is inputting data?

Example: If the user enters a name of a team, the league and group should be automatically displayed in the next fields. The data would be coming from the other table?
So how do I link tables together?

This question pops up after days and days of posting 10 posts a day?

Example: If the user enters a name of a team, the league and group should be automatically displayed in the next fields. The data would be coming from the other table?
So how do I link tables together?

Ideally, the source of your form should be the query that inner joins all fields from the two related tables. If you join your fields at the data level like that, no code on the form is required really.

[newtoAccess]

OK will give it a try.
How does the query fill the tables?

[ajetrumpet]

OK will give it a try.
How does the query fill the tables?

it doesn't fill the tables. it queries FROM the tables. make sense? each table has fields, one field is the link, the query's result is every field from every table.

attached is an example of how to do something like this...

[newtoAccess]

So do I create a From that shows the fields in all linked tables?

[ajetrumpet]

create an autoform from the query. its that simple.

[newtoAccess]

Thanks again

[l3111]

Hi

I have two forms - a referrals form and an other services form. Once a referral has been entered, an referral reference is assigned to it by means of an autonumber. this is the primary key of this referrals table. I have created a relationship between this field and one with the same name in the other services table. my aim is that when a referral is complete and a user uses the command button that opens the other service form, it automatically populates the referral reference field with the SAME reference number from the referral.
i have trying to complete this for weeks and would really appreciate some help. from what i have found a query seems to the best bet but i have NO IDEA how to design one to do this?

Damsel in Distress!!

l3111, Manchester, UK