Skip to main content
Question

Can I add and edit a date field from a parent table on a child table (on the form)

Forum|alt.badge.img+7
I would like to be able edit a date field in a parent table ( Patient table) from several different child tables as well as enter account notes from my child tables (tables names are estimate and invoice) in my App.  I know I cannot edit a look up field so I am trying to figure out how to add various fields from my parent tables (Patients table) to my forms/table in the above child tables.  

I have the table relationships built, and have tried many ways, but just cannot figure this out. 

Currently, I have to leave the child table to go to the parent table and/or another child table to edit various fields.  

Any ideas I can try out?

Thanks


------------------------------
Kelly Lyons
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    I usually accomplish this by making a custom button that says something like 'Edit Parent Details'.

    Then on the parent I create a new form with only the fields on it that I want them to be editing at that time.

    Back on the child, simply make the button open up a small popup window in edit mode on the new form, on the parent record. To be extra slick you can use a code page that will auto close the pop up when done editing. If you want to go the extra mile I can lead you to those directions.

    ------------------------------
    Mike Tamoush
    ------------------------------
    MarkShnierYou
    Forum|alt.badge.img+24
    One way is to create a sort of temporary field on the child table and then trigger an Automation or a Pipeline to write that data back up to the parent record.

    But a better way is to create a Report Link field to display selected fields from the Parent as an embedded report right on the child table.  So edit the child and set the Form to allow the embedded report to go into grid edit mode. The the workflow is to update the parent in grid edit (it will be a one record report) and save.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement