Show all records?

[Daniel Shanahan]

Is it possible to have a portal show all the records of a particular layout? I have a layout (Vans) with six records. The first five are particular vans and their seating capacity. The six record is labeled "Unassigned." Every person is automatically give the foreign key ID for the "Unassigned" van. I have one portal in the van layout that lists all those people and I have included buttons to change the foreign key and reassigning them to another van. So far so good. I have that up and running. I would like to include a second portal on the screen with a list of the van names and their available seats. So, when I assign a person to a van in the first portal, the second would automatically populate, essentially giving me information about that new van. This would eliminate the need to go back and forth to the other five fields to check on the seating capacity.

Is this possible?

Thanks

[Genx]

Ah yeah.. if i understand what you mean

Just relate any two fields between your layout TO and your Portal TO via the cartesian Join (the X thing). This will show you every record regardless of any relationship (or lack thereof) between the data.