Don't try to link the PK fields! If you have just one Tag_Misc for every
client, is there a reason it cannot appear in the main client record?

The "forms guys" cannot overcome an unworkable design. It's hard to know how
it worked before, but you are **severely** limited by the design if you have
no freedom to change the table structure. Good luck.

atledreier wrote:
Due to limitations regarding my client I can't change the structure of
the tables.

One tag_misc for every Tag is exactly what I want, really, but I guess
I can enforce this on form level and just tell my users this is what
you get.
But after reading this, I have no idea how this has worked
before! :-)

I guess I'll shuffle over to the Forms guys and see if they can help
me out with something.

Thanks for your help!

- Atle

If there could be more than one record for Tag_Misc, Tag_Failure_Mode, and
Tag_Format, those tables need to one-to-many. Â*If they are one-to-one there
[quoted text clipped - 131 lines]
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/20...

--
Message posted via http://www.accessmonster.com