snaves Posted August 24, 2009 Posted August 24, 2009 My problem is two-fold-I have a parent and child database establish. In the child dbf--there is a narrative text field called contactrecord-it expands with the users input (which can be long). In the parent database, I created a portal to pull in all the related records so the user can view all their contacts in one place. How do I make the "contactrecord" input field expand and shrink as needed in the child database? I also include the fields of date and time in the portal. How do I make the portal field expand and shrink based on the childbase field? I also include the fields of date and time in the portal. I am a beginner in programing the scripts-- portal.PDF
bcooney Posted August 25, 2009 Posted August 25, 2009 Portal rows are fixed in size in Browse mode. You can create a report based on the child table, and use Sliding to decrease the row height, based on content.
comment Posted August 25, 2009 Posted August 25, 2009 You could also place an 'expanded view' next to the portal - see an example here: http://fmforums.com/forum/showpost.php?post/333539/
snaves Posted August 28, 2009 Author Posted August 28, 2009 Thank you for your replies-I am bummed the portals can not be scripted for resizing depending upon the field being pulled in. (But to be honest, I haven't even conquered the whole sliding field thing yet). In the database definitions, I did this (kind of proud of myself;) Case ( ContactType = "Phone call made to"; 1; ContactType = "Phone call rec'd from" ; 2; ContactType = "Emails sent to" ;3; ContactType = "Emails rec'd from"; 4; 0) And then I created If (CaseContactNote ≠ 0 ;VisitNote ;"" ) I already have a button scripted to go into the parent dbf-related record where the portal resides for viewing the records. But how do I script the button to only display the 1-4 notes in the portal and attach to the “go to” button?
Recommended Posts
This topic is 5566 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