Jump to content
Sign in to follow this  

How To View Single Record Of Multi-Line Portal

Recommended Posts

I have two databases, Parent and LineItems. I want to be able to display a selected description of the data in a portal with numerous items. I then want to display all the information of one record in a large, single record portal. Finally, I want to show the user which line item is select in the portal by highlighting the portal row.

Currently, I am setting a number field with a Max( LineItem::Serial_# ) + 1 and a decsending sort to highlight and dislplay the current record in the single portal. It does cause me a little grief when a line item is duplicated or deleted.

Does anyone have another approach?


Share this post

Link to post
Share on other sites

Make the highlight a calculation of Case( Parent::global = serial, highlight ). When a row is selected, Set Field [global, LineItem::serial].

Share this post

Link to post
Share on other sites

Used a concatenated key in the LineItems file:

KeyField & "_" & Serial


Set Field [ KeySinglePortal , KeyField & "_" & LineItems::Serial ]

(KeySinglePortal as a text field)

Thank you.

Share this post

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.