crazybake Posted July 12, 2011 Posted July 12, 2011 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 Posted July 12, 2011 Posted July 12, 2011 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 Posted July 12, 2011 Author Posted July 12, 2011 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 Posted July 12, 2011 Posted July 12, 2011 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 Posted July 12, 2011 Author Posted July 12, 2011 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?
Recommended Posts
This topic is 4903 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now