Very Basic, maybe not possible, but anyhow,
I want to have a Master Form as my Many table. Then my Child form as the One table.
Scrolling through my Master Form records I want to see my Child Form change accordingly. I want to be able to add a new One record to my Master(Many) or assign a previous used record.
I realize this is hard 'cause the One record don't know which Many to choose, but there must be a way.
I can't do it the other way, 'cause I have several One tables and they all refer to the Many table which is the main table.
Any comments.
Thanks
I want to have a Master Form as my Many table. Then my Child form as the One table.
Scrolling through my Master Form records I want to see my Child Form change accordingly. I want to be able to add a new One record to my Master(Many) or assign a previous used record.
I realize this is hard 'cause the One record don't know which Many to choose, but there must be a way.
I can't do it the other way, 'cause I have several One tables and they all refer to the Many table which is the main table.
Any comments.
Thanks