By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Problems updating/adding records in Access 97

P: n/a
Hi guys,

I'm having a problem getting newly added records to cascade through to
other tables in the query I use for a form. If I add a record to the
form then the additions are fine as long as the fields I enter are only
from the main table. If I try to add records that use anything from
the other tables then records appear to be added but not the main ID
field (these tables are joined via a One-to-Many relationship in the
DB).

Is there a way that anyone knows to get the primary key from table 1 to
copy into table 2?

I probably haven't been very clear on this so if anyone isn't sure then
let me know.

All the best, Dean...

May 22 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.