Jump to content

Counting help needed !!


This topic is 5714 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5714 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.