joining two tables

A

anonymous

Hi all,
I am trying to create a simple database that has two
tables.
1 table has workstation id and other fields relating to pc
2nd table is setup to enter software installed on the
workstation
I joined the two tables by creating a workstation id in
the 2nd table and joined as a one to many.
Is there a way to make the workstation id automactically
showup in the software table workstation id field?
My goal is to have a setup where the first tab shows
workstation table info and a second tab shows software
entries for that workstation but I don't want to have to
enter the workstation id each time I enter new software.
I guess what I am asking is can the 2nd table have the
workstation field auto fill with the workstation Id from
the first table?
Thanks in advance for any help
Sherry
 
K

Kevin Sprinkel

My goal is to have a setup where the first tab shows
workstation table info and a second tab shows software
entries for that workstation but I don't want to have to
enter the workstation id each time I enter new software.
I guess what I am asking is can the 2nd table have the
workstation field auto fill with the workstation Id from
the first table?
Thanks in advance for any help
Sherry
Click to expand...

Hi, Sherry.

Create a continuous subform for the many side, and insert
it on a main form based on the one side. Set the Link
Master Fields and Link Child Fields properties of the
subform control in the main form to the WorkstationID
field in the main form's source table/query and subform's
source table/query, respectively.

Then, when you drop into the subform to add the various
software records, IT KNOWS :) that you're adding these
records to this workstation, and will fill in the linking
foreign key automatically.

HTH
Kevin Sprinkel
 
G

Guest

Can you tell me how to set the link master field and link
child fields properties of the subform control . I can't
find where you link them.
I went to properties of the table and properties of the
subform.
Thanks in advance
Sherry
 
R

Rebecca Riordan

It's on the Data tab of the properties window of the subform.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Top