See all data in one layout

[relling]

The attached image shows the relationships I have established among six tables. This all works in that I can assign courses to groups and resource types to groups.

What I would like to be able to do is to see all the red marked data for all courses. In other words, every single resource for each course would show up in one giant table layout. It would be ideal to see the blue marked elements as well (and I realize there will be duplicate entries in a table which is fine), but I can live without them.

When I create a layout with the fields I'm interested in, I only get the first portal row for courses and just one resource record instead of dozens.

Suggestions? and, in advance, thanks!

[efen]

Welcome to the forums.

Your present relationships only allow you to view "one" record. You need to create extra table occurrences using cartesian joins [x] so that you can view all records in other tables.

[relling]

Thank you for the quick response.

Do I need to replicate all table occurrences or just a subset?

[efen]

To see all the resource records from the course table just create a cartesian join from the courses table to another occurrence of the resources table. This will allow you to have a portal "table" on a courses layout showing all the resource records.

[relling]

Thanks, I'll give it a try

[relling]

Tried a couple variations on your recommendation

1. duplicated resources and [X] to courses

2. duplicated resources and courses and then [X]

3. duplicated resources and [X] to types leaving all the other tables with original [=]

Created a variety of layouts and portal combinations and, at best, what I get is

1. every course shows the same resources even though only 3 courses have been assigned to a group

2. listed resources are not the complete set of what has been assigned

3. portal does not show vertical scroll bar

4. portal records are editable which is NOT a good thing (but I'll live with it if I have to)

When I attach the "consolidated" layout to a variety of tables (just for fun) I get 2-4 as above, but I then do get a subset of classes, not every class (so this is closer to what should happen).

Since text explanations tend not to be very good, I've attached a copy of the file (admin/admin) for you/someone to look at.

This is my first attempt at [X] joins so I very much appreciate your patience!

Ron

WebCheckoutCopy.zip

[efen]

To try to answer your questions:

1 Not quite sure here that I understand what you mean. Is this the consolidated layout? The portal does show all resource records because that's the way it is set up.

2 All the resources are there - you can't scroll the portal because ...

3 You need to add/format a line to show the scroll bar (in Layout mode go to status area and select from the bottom three buttons line width and colour).

4 In Layout mode select the fields, right click and select Field/Control. Select Behaviour and unclick "Allow field to be entered".

You don't specify a portal row to delete on your button? Why have it where it is?

Why not have all the lists/tables of information in form layouts with [same size/position] portals (with X joins to show all records in the respective tables)? There would be less "jumping about" for the user when you change layouts if you took that approach.

[relling]

Okay, I have the scroll bar - silly me.

I do see all the resources now, but that's an even bigger problem. I only want to see the resources that have been related to each course through the course-group-type-resource relationships.

Right now, every course shows every resource.