portals or repeating fields

[crazybake]

I cannot find the straight answer and this seems very rudimentary... sorry. I just cannot seem to get it right.

I have a table called Users with a layout of user information. There are approximately 200 records in this table. I want to create a new layout that has the entire list of students in rows. The purpose of this is to create a "Quick Link" to user information in the other layout.

I was thinking portal - but it seemed to me that I need to get the list into a repeating field and use the (show range)to decide how many would be in each column. I created a self join UserID as the key field and then I am stuck.

Help on this one?

[bcooney]

Do "users" = "students"?

If so, all you need is a list view layout based on the same table. Then, put a button in the body part of the list view that does Go to Layout "MyFormLayout".

[crazybake]

Do "users" = "students"?

If so, all you need is a list view layout based on the same table. Then, put a button in the body part of the list view that does Go to Layout "MyFormLayout".

Sorry.. A confusing post with missing details. I have a table called users. Within the table I have a field called firstLast. The is the first and last name of the user. I was hoping to view these records in columns and rows... Say one layout with 8 columns and 25 rows (with only the firstLast field). I understand about the list view, just confused on the rows/columns layout... While at the same time, keeping the field as a clickable button.

[comment]

A repeating field shows multiple values in a single record. You want to see multiple records - meaning either a list view or a portal. You can place 8 portals, each 25 rows tall, side by side and set the initial row to 1, 26, 51, etc.

I created a self join UserID as the key field

If you want to show all records in the table, use the x relational operator.

I am not sure what you'll do if the number of users exceeds 200.

[crazybake]

The portal will work fine for now. I will not have more than 200 users. I have the field firstLast in the portal and set the portal to show specific rows. Thanks for the help... just one more thing. I have this firstLast field in the portal set as a button so that it displays student info in a new window when clicked... However, I need it to go to the related student info in a new window. Cannot get this to work in the portal, but could in list view. It just goes to the first record, ideas?

[comment]

Did you set the button to Go to Related Record[]?