problems linking many to many tables

[AndréG]

I am developping a new application with access 2007.

In it a I am adding links to an external database containing many-to-many
relations using the new "Multivalued' fields introduced in access 2007.

I am not sure but it seems to me there is a problem with that.

The many-to-many relations from the external database are not properly shown
in the relations view of the application's database. instead there is a link
to an unrelated table with name starting with "f_" and a single field called
"value".

Does any one knows what that means and how to deal with it.

Did someone already experience with that stuff this way ?

Will it work as expected and if not is there a workaround or should I avoid
using that new feature ....

 

[Jeff Boyce]

Someone may offer a work-around.

If you are familiar with the use of a third table to resolve a many-to-many
relationship, you can do so directly, rather than relying on a multi-valued
field. This should give you more control over how it is implemented.

Regards

Jeff Boyce
Microsoft Office/Access MVP