April 26, 201312 yr Hi, i have a table called "stock" and portal on the admin layout displays the data from the table no problem. I need to put another portal on the user layout displaying the same data as on the admin layout. I need the portal to show the same data on every record, so when a user goes to next record the stock data is still displayed in the portal. i have tried self join but cannot get the portal on the user layout to show anything at all. Any Ideas?
April 26, 201312 yr What does the relationship between the table occurrence (TO) your admin layout is based on and the TO the portal is based on? And what does the relationship look like between the user layout TO and the portal TO? If you want to show the same stock records regardless of the current user record, you probably want a cartesian join (X), but we need more details to be certain.
April 26, 201312 yr Author That is exactly was was needed. I read up on it and implemented it and it worked.! Many Thanks.
Create an account or sign in to comment