Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

HELP with update with one to many tables

Posted 19 Mar 2002 20:16:51
1
has voted
19 Mar 2002 20:16:51 Rick Harding posted:
I have an access database with a one to many relationship. I need to find a
way to edit a single one on the many side. When you do an object-live-update
record you have to specify the unique key but I can't. The ID isn't unique
in the table. Is there some way to specify this one instance to edit it?

www.ricks-web.info/research/judge_list_admin_only/edit_delete_judge_s
elect.asp

is the url I'm working on. Select a judge to edit and you see their contact
info on the left (the one table) and their assignment information for the
past two years on the right (repeat region and the many side) I want to have
the url at the bottom link to an edit page for that one instance of the
many. If you change it however, it changes both the 2001 and 2002 years.

I appreciate any help you can offer.

Rick


Rick Harding
U of M CS Student / Network Admin for MSU FAME
"Techies just think differently...at least that's what they keep telling me"

Reply to this topic