Skip to main content
Question

Adding a related child record with a button

  • August 26, 2019
  • 0 replies
  • 188 views
​​Hi, This seems really basic but I can't find any instructions on how to do this.

I have a form that shows a parent record and all the child records related to it. 

I have a button to add new child records.

The button does not populate any info to tie the new child record to its parent. It lets the user pick from a drop down.

I do not want the user to pick. I want the parent record's info to be populated automatically and immediately on the child form.

Please help. Thanks!

------------------------------
Audrey
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • August 26, 2019
    When a new relationship is created, the default [Add...] button will be programmed to populate the related reference field value with the parent-key field (usually Record ID#) value.  The related reference field, often displayed on the child-record form, will only show the 1st-field in the record picker, set in the Parent-table.  If your record picker first-field value does not have any data; this can be confusing and look like it is not connected to anything.

    The related reference field is still selectable; and can be changed, which is probably why it looks like it is not populating.

    If you have a Proxy Field in your relationship; you cannot put both the Related Reference AND the Proxy field on the form in Add/Edit modes because they conflict with each other.

    Can you post an image of what you Add-Child-Form looks like with the Related Reference or Proxy field visible?

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Terms & ConditionsAccessibility statement