April 12, 200520 yr I have a contacts database that mainly consists of a pair of tables: Contacts and Contact_Notes. The Contact_Notes database has (3) fields: a Timestamp field, a Contact_ID filed (which is the key field that relates the aforementioned tables), and a Notes_Content field. The idea is that any time a user has communication with someone in the database, they click a button on the main Contacts layout that activates a script that is supposed to create a related contact note record, enter the timestamp, and jump to the Notes_Content field of that record, ready for the user to type their note. The timestamp and Notes_Content fields are displayed through a portal on the main Contacts layout. All of this works fine, except for the fact that I can
April 13, 200520 yr the attachment takes care of the jumping to field thing, though i dont know why it wont work for you; it is only two script steps. i think there is no way to resize portals / fields based on their content in normal browse mode. Untitled.fp7.zip
April 14, 200520 yr Author I figured it out - sorting the portal rows properly did the trick. Regarding the other issue, I'm thinking that there might be a way to overlay a text field over the portal that combines the text from the related contact note records, with a return between each entry. I seem to remember this type of solution from years ago, but can't quite remember how to implement.
Create an account or sign in to comment