Counting help needed !!

[Matteo]

Hi all,

Here is my situation. I have made a FM file to keep track of the project and users that are using my lab.

Here are the main fields:

UserName

ProjectID

Belongto: Valuelist= InsideUniv, OutSideUniv, Companies. Formatted as a radio button list

Status: Past, Actual, Potential

The problem is that there could more than one user per project and also a user can have more than one project going on.

thus, when I do simple summary counting, I don't get the right number of users or project but I've solve that by creating a valuelist out of UserName field and count the items.

But, I'd like to count the number of Past, actual, and potential project as well as the number of insideuniv, ousideuniv and companies project. I've been struggling to find a solution without success.

Best would be to have the calculation results during browsing but in report it would be ok too.

Is there a solution to that ?

Or do I need to rebuild my DB in an other way (one file for users, one file for project).

Thanks a lot in advance.

Matteo

[Ender]

Yes, you should use separate files for each entity.

The problem is that there could more than one user per project and also a user can have more than one project going on.

This means one file for User, one file for Project, and a join file, User-Project.