Linking fields between tables or forms.

[vik.sinha]

Hello,

I need some guidance. My ms access skills have gone very rusty...and i
forgot how to do this.

Table 1 (Personal Info)

ID --- Name --- City
-----------------------------
01 AB NY

Table 2 (Work Info)

ID --- Industry --- Position
------------------------------------
01 Medical Lawyer
So when I enter information on Table 1, i would want to work on the
same ID on table 2. I do not want to have the option to enter a
different ID on table 2.

As of now, when i enter table 2, I have a drop down box where I select
the ID from table 1 such as 01,02,03 BUT I do not want he option to
select, I want to be forced to id=01 if I have just entered that
information on table 1.

I am not sure if I am being clear. so...

Table 1

ID --- Name --- City
-----------------------------
99 xy NY

now I go to table 2

ID --- Industry --- Position
------------------------------------
automatically filled -- --- anytext ---blah
with the value of 99
since i have just
finished entering
that on table 1.

End goal is to use forms instead of the tables to enter the
information..

Thanks

Forumware

[luanhoxung]

are ID in table 1 and table 2 primary key ??
if they are primary key, why dont u add them in only 1 table ????
table(personal information)
ID---name---address---job---position

[Bas Cost Budde]

The information you sketch here belongs in one table.

vi*******@gmail.com schreef:

Hello,

I need some guidance. My ms access skills have gone very rusty...and i
forgot how to do this.

Table 1 (Personal Info)

ID --- Name --- City
-----------------------------
01 AB NY

Table 2 (Work Info)

ID --- Industry --- Position
------------------------------------
01 Medical Lawyer
So when I enter information on Table 1, i would want to work on the
same ID on table 2. I do not want to have the option to enter a
different ID on table 2.

As of now, when i enter table 2, I have a drop down box where I select
the ID from table 1 such as 01,02,03 BUT I do not want he option to
select, I want to be forced to id=01 if I have just entered that
information on table 1.

I am not sure if I am being clear. so...

Table 1

ID --- Name --- City
-----------------------------
99 xy NY

now I go to table 2

ID --- Industry --- Position
------------------------------------
automatically filled -- --- anytext ---blah
with the value of 99
since i have just
finished entering
that on table 1.

End goal is to use forms instead of the tables to enter the
information..

Thanks

Forumware

--
Bas Cost Budde
Holland

[Larry Linson]

If you create a Form, then open the Form for accessing Table 2, using the
DoCmd.OpenForm statement, and specify a WhereCondition. Check Help on
DoCmd.OpenForm for details. There is no comparable method for opening a
Table to a particular Record and passing the key.

Larry Linson
Microsoft Access MVP

<vi*******@gmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

Hello,

I need some guidance. My ms access skills have gone very rusty...and i
forgot how to do this.

Table 1 (Personal Info)

ID --- Name --- City
-----------------------------
01 AB NY

Table 2 (Work Info)

ID --- Industry --- Position
------------------------------------
01 Medical Lawyer
So when I enter information on Table 1, i would want to work on the
same ID on table 2. I do not want to have the option to enter a
different ID on table 2.

As of now, when i enter table 2, I have a drop down box where I select
the ID from table 1 such as 01,02,03 BUT I do not want he option to
select, I want to be forced to id=01 if I have just entered that
information on table 1.

I am not sure if I am being clear. so...

Table 1

ID --- Name --- City
-----------------------------
99 xy NY

now I go to table 2

ID --- Industry --- Position
------------------------------------
automatically filled -- --- anytext ---blah
with the value of 99
since i have just
finished entering
that on table 1.

End goal is to use forms instead of the tables to enter the
information..

Thanks

Forumware