Jump to content

how to add text from parent record to child in portal

Recommended Posts

Hi all!


I’m hoping you can help me out with a portal problem I can’t figure out. I’ve probably just overlooking something obvious. I haven’t posted to the forum before but have been a frequent visitor ;-)

For clarity, I've attached the screen shots in a PDF. If necessary I can also post the file.

I have a portal that creates child tables and it all looks fine, but I would like to have one field that is keyed in outside the portal (fos_file_name) but then used in each of the child records.


I have this set up so the fos_root_name is at the top.  When that is keyed in I would like to have it placed in each of the child records in the portal with a sequence number (using portal record) appended to the fos_root_name. This would be triggered once the date or the operators initial are entered.

Everything works fine with the exception of the fost_root_name. I’m assuming I need a variable to store this text for the parent record until a new parent (artifact) is created.


I can get the sequence number to appear, and the primary and foreign keys are looking good, I’m just not sure how to script this fos_root_name.


Any help would be wonderful!

field not displaying in portal.pdf

Share this post

Link to post
Share on other sites

If I understand you correctly you should be able to create a calculation field in the child table << ParentTable::fos_root_name & ChildTable::sequence number >>

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


Important Information

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