Link Access 2002 tables...

  • Thread starter Thread starter H. de Roode
  • Start date Start date
H

H. de Roode

I'd like to link two access tables with the first field
(serial number) of every table. Once a serial number is
entered in one table, I'd like to automatically create a
new record in the other table with that (new) serial
number. How can i manage this?

Thanks,
Herman
 
Create a relationship between the two tables based on that serial number
field. Then, after you create a record in the first table, you can enter a
new record in the second table using that same serial number.

If what you want is to create some type of record in the second table when
the first table gets a new record, you'll need to provide more info about
how/when you create the record in the first table. You'd need to run a query
most likely to create the record in the second table. However, usually this
isn't done until you're ready to enter a record in the second table.

Please provide more info about what you're wanting to accomplish...I'm
guessing that the answer may be different from what you're thinking it needs
to be with respect to this second table.
 
Back
Top