general questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike B - 31 Mar 2005 20:37 GMT

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

Reply to this Message

John Vinson - 31 Mar 2005 22:45 GMT

>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
[quoted text clipped - 7 lines]
>content's syncronized? Most of the data for form 1 comes from table A but
>some comes from table B

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]

Reply to this Message