Joining Tables

  • Thread starter Thread starter Ktowner
  • Start date Start date
K

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
 
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
Click to expand...

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.
 
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.
 
Back
Top