merlyn383 Posted November 1, 2004 Share Posted November 1, 2004 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? Link to comment Share on other sites More sharing options...
transpower Posted November 1, 2004 Share Posted November 1, 2004 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. Link to comment Share on other sites More sharing options...
merlyn383 Posted November 1, 2004 Author Share Posted November 1, 2004 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>" Link to comment Share on other sites More sharing options...
transpower Posted November 1, 2004 Share Posted November 1, 2004 How is your Relationships Graph structured? Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 You don't need a relationship. Just define a value list using values from CourseName. Link to comment Share on other sites More sharing options...
merlyn383 Posted November 1, 2004 Author Share Posted November 1, 2004 But how do I populate CourseNames with the various courses from multiple databases? ------------------------- -Kevin Link to comment Share on other sites More sharing options...
merlyn383 Posted November 1, 2004 Author Share Posted November 1, 2004 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 Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 Create one value list for each applicable table. Then create an unstored calculation to concatenate them all ValueListItems( Get(FileName); "valuelist1" ) & Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 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. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted November 2, 2004 Share Posted November 2, 2004 I second that. You'd run into reporting nightmares with your current settings even if FM7 helped ia bit in consolidating these data flaws. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7115 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 accountSign in
Already have an account? Sign in here.
Sign In Now