self-join question

August 24, 200718 yr

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?

August 24, 200718 yr

Author

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, 200718 yr by Guest

August 24, 200718 yr

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