general questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables that are linked by an aiutoindex value as a key. I have
noticed that when entering data for a single table (and using the default
navigation buttions) acess seems to be good at saving your data even if the
form is partialy completed.

Whats the best way to add the record to the joined table (I would really
like that to happen when the record in the first table is created. Do the
navigation controls at the bottom of the form fire events in the same way
that command buttons do? Lastly (this may be related how do I keep the form
content's syncronized? Most of the data for form 1 comes from table A but
some comes from table B

thanks
Mike
 
I have 2 tables that are linked by an aiutoindex value as a key. I have
noticed that when entering data for a single table (and using the default
navigation buttions) acess seems to be good at saving your data even if the
form is partialy completed.

Whats the best way to add the record to the joined table (I would really
like that to happen when the record in the first table is created. Do the
navigation controls at the bottom of the form fire events in the same way
that command buttons do? Lastly (this may be related how do I keep the form
content's syncronized? Most of the data for form 1 comes from table A but
some comes from table B
Click to expand...

Adding empty "placeholder" records to a related table is a VERY BAD
IDEA. They have a nasty way of never getting filled in.

I would suggest that you use a Form for the "one" side table, with a
Subform for the related table. Use the Autonumber field as the Master
Link Field, and the long integer field (*NOT* an autonumber, you can't
use an autonumber as a foreign key) in the related table as the Child
Link Field. Access will keep the records synchronized correctly.

The Current event fires when you use the nav buttons, if you need to
do something in code whenever you move to another record. However, no
code is needed if you're using the subform, Access takes care of it
for you.

John W. Vinson[MVP]
 
Back
Top