New Many to Many options in Access 2007

[vapid2323]

Ok the only way I have ever created a Many to Many connection was with a Join table.

With my most recent project I am having a really hard time creating a UI that is easy for my users to work with. I came across the new multivalue option for the lookup tables in access 2007.

It seems like not a whole lot of info its out on working with this so I wanted to see if anyone had experience with this option.

I have done some testing and it looks great to simplify my UI without any code but I am worried that I won’t be able to report on the fields as easy as there is no added join table... well none that I can see.

Also I am aware that if i ever need to grow up to a SQL database this will cause me issues.

So I guess I am trying to see if there are any large issues that I should be aware of before I continue.

 

[Galaxiom]

There is little information because the users with most experience avoid multivalue fields like the plague because they introduce more problems than they solve. They are far more complex to query than a related table structure.

Like many of the "user friendly" innovations introduced by Microsoft in Access they tempt the novice with a facade of simplicity only to bite back later.

Split forms are another lame horse from the same stable.

 

[jdraw]

Perhaps you could tell us more about your application by describing the many to many relationship. I don't have Acc2007, but I think table structures /relationships can be devised to solve the issue.
I wouldn't necessarily try some new feature of a software package when relational structures may suffice.

Just my 2 cents...

 

[Banana]

There is little information because the users with most experience avoid multivalue fields like the plague because they introduce more problems than they solve. They are far more complex to query than a related table structure.

This.


Would one of various samples offered in this thread help with your UI issue?

 

[vapid2323]

Perhaps you could tell us more about your application by describing the many to many relationship. I don't have Acc2007, but I think table structures /relationships can be devised to solve the issue.
I wouldn't necessarily try some new feature of a software package when relational structures may suffice.

Just my 2 cents...

Sure thing, but my issue is not the relationships as much as how to make it easy for the users to add data into the tables. I am getting better at VBA/SQL but this is a little over my head.

I attached the Relationships for my join tables so you can see. This one is a few days old and I have since then merged the tblAuditor and tblSiteStaff tables.

The database is to track four types of audits across a set of sites, I also need all the staff for the sites etc.