self-join question

[Cluso]

I want to have an option to view data in a form or in a table.

The way I was thinking was I would create a self-join to the table in question, then put up a portal on a tab field; the tab is activated and the portal appears when the user clicks on the "view as table".

I joined the tables using a field (lets call it "A") and I want to list all the values of "A" for all records in one portal on each record.

My only question is how do I get the portal to show all the records from the table? I tried to make the portal and just put the fields in as connected to the parent table, but only one record shows up, instead of a list.

Now that I'm thinking about it, though, perhaps I just want to create a whole new table, and put the portal in it, and forget the self-join. Then, I'd have only one record in this new table. Would that be a better idea?

[Cluso]

ok so if I make a new table/layout combination and link my original table with the new one by a global variable cum match field which always has the same value on every record in the original table, create one record in the new table with the same value in the match field and a portal, I can get all the records to display

I dont like it though, because I'm cluttering my layouts with even more random placeholder fields. Is there any other way to do this?

Edited August 24, 2007 by Guest

[AudioFreak]

The fields used to make a portal populate don't "have" to be visible on the layout. Just make sure the data you want in them is there and will always be there.

Just because a field isn't visible on a layout doesn't mean that the field can't hold data.

Michael

[Cluso]

word

I'm just wondering if its possible to do it without making more fields to hold data; it seems like all my solutions include a dozen hidden fields...

[AudioFreak]

Pretty sure they have to be there.....lol.

I got away from hiding them and started using a layout to put them.

Michael

[Cluso]

Wait, I can make more than one layout for one table? And put all my hidden fields in that other layout??

[Lee Smith]

You can create an infinite amount of layouts for any TO, and the layouts can contain any number of fields you want.

HTH

Lee