Select one from one to many subform

[djj55]

Hello, Access 2002
I have a form that has a one to many relationship to the subform. No problem there.
What I need is for the user to be able to pick one recorded to be the main record associated with the parent form.
Joe Doe (Table A - parent form)
-- Address 1 (Table B - sub record 1)
-- Address 2 (Table B - sub record 2)
-- Address 3 (Table B - sub record 3)
Only one record is shown at a time on the subform, so they need to navigate to see all three addresses in this example.

Say the user picks Address 2 which would mark Table B, so far so good.
The problem is how do I prevent Address 1 or 3 from also being marked as the main address?

I want only one flag for Joe Doe in Table B.

I hope this makes some sort of sense.

Thank you for your assistance.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[djj55]

Well, I remembered that there is the AfterUpdate event. That is what I get for working with T-SQL so much. I will use the event to check for existing flags.


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!