Joining Tables

[Ktowner]

I'm a novice user of Access 07. I am tring to join 2 tables where the data in
the joining record field in one table would auto generate the same date in
the joining record field of the second table. Is this possible? If so can you
walk me thourgh it?

Thanks

Ktowner

 

[John W. Vinson]

I'm a novice user of Access 07. I am tring to join 2 tables where the data in
the joining record field in one table would auto generate the same date in
the joining record field of the second table. Is this possible? If so can you
walk me thourgh it?

Thanks

Ktowner

You can use a Form based on the one table, with a Subform based on the second
table, using the joining field as the master/child link.

You should generally NOT use table datasheets for editing or working with
data. I almost hate to say it, because it's a Very Bad Idea on Microsoft's
part, but you can (in 2007) use <shudder> Subdatasheets. I'd really recommend
using forms instead though.

 

[KARL DEWEY]

Make the one table field a primary key. The field in the second table must
be of same datatype -- text-text, autonumber (Long integer)-long integer,
etc. and is known as foreign key.
Create a relationship of one-to-many from the one tpo the second, selecting
Referential Integerity and Cascade Update.
Use the two tables in a form/subform (one/second) seting the Master/Child
links on the primary key/foreign key. The foreign key does not need to be
visible in the subform.

 

[Steve]

If you join a field in table 1 with a field in table 2 in a query, you will
only see the records in both tables where the value of the joining record
field is the same in both tables. Is this what you are looking for?

Steve
(e-mail address removed)