>>Hi Matt,
>>Don't open your tables with USE in the form.
>>Insert your tables in Data Environment of the form.
>>So you insert and the relationships.
>>
>
>Ok. I see it work to add a relationship when you add it to the DE... But, I have about 35 forms that I've had for years, and all the data tables and relationships for them are set in procedure code that is called from the form Load() event.
>
>I guess I should just stick with my existing way.
IMHO I haven't seen reason to use a DBC aside from being able to play sorta like a real database while adding another layer to corrupt or be a pain when used in the DE.
That was one of the reasons I switched to SQL backend many years ago.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________