Jump to content
Sign in to follow this  
merlyn383

Cartesian Join/Value List Question

Recommended Posts

If I have multiple tables that each have records of courses in them (from different subjects) and each record has a field for the course name ("Course"), and I want to create a value list that has the names of all courses from all subjects, shouldn't a cartesian join do this? What I tried to do is below, but it doesn't work:

Admin::CourseNames x Subject1::Course

as one relationship and:

Admin::CourseNames x Subject2::Course

as another relationship and then just defined the value list to take values from Admin::CourseNames. Any ideas on what I'm doing wrong?

Share this post


Link to post
Share on other sites

A Cartesian join means that all records in one table are related to all records in another table. It would mean, for instance, if you had students in one table and courses in another table, then all students would have all courses.

I doubt that's what you want. I think you need just a regular equijoin between the tables, with the value list being the course field from the second table. Don't show just the related records; show all.

Share this post


Link to post
Share on other sites

Ok, my bad. I thought that i needed to use the cartesian join in order to get the values across all the records. Thank you for straightening that out for me.

I tried the equijoin relationship so that the relationships are now:

Admin::CourseNames = Subject1::Course

and:

Admin::CourseNames = Subject2::Course

and the value list is still created using Admin::CourseNames, but the value list still comes up with "<no values defined>"

Share this post


Link to post
Share on other sites

How is your Relationships Graph structured?

Share this post


Link to post
Share on other sites

You don't need a relationship. Just define a value list using values from CourseName.

Share this post


Link to post
Share on other sites

But how do I populate CourseNames with the various courses from multiple databases?

-------------------------

-Kevin

Share this post


Link to post
Share on other sites

Ok, let's see if i can state this clearly enough.

I have one table (Admin) that contains the field CourseNames.

Another table (Math) that contains the field Course.

Each record contains the performance of a student in a particular course (Calculus 1, Statistics, Calculus 2, etc.)

A third table (Chem) that contains the field Course.

Again, each record contains the performance of a student in a particular course (General Chem, Organic Chem, etc.)

the way the relationships are as of this moment is:

One relationship-

Admin::CourseNames = Math::Course

Second separate Relationship-

Admin::CourseNames = Chem::Course

Then, my value list uses the value from the field Admin::CourseNames.

Does that help?

---------------------------

-Kevin

Share this post


Link to post
Share on other sites

Create one value list for each applicable table. Then create an unstored calculation to concatenate them all

ValueListItems( Get(FileName); "valuelist1" ) &

Share this post


Link to post
Share on other sites

It would be much easier for you in the long run if you kept all courses in one table with category and subcategory fields for them.

Share this post


Link to post
Share on other sites

I second that. You'd run into reporting nightmares with your current settings even if FM7 helped ia bit in consolidating these data flaws.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jarvphot 
×

Important Information

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