Adding a related child record with a button
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 c...
Forum Discussion
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
------------------------------
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
------------------------------
Here is the formula for the button field.
URLRoot() & "db/" & [_DBID_ABSTRACTION] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl()
------------------------------
Audrey
------------------------------
URLRoot() & "db/" & [_DBID_ABSTRACTION] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl()
------------------------------
Audrey
------------------------------
- Audrey,
There is nothing wrong with your formula; as long as FID 16 is the [Related Reference Field] joining the two tables.
Probably you are not seeing the record picker show a valid entry, or you have both the Related Reference field and a Proxy field on the form.
I suggest you call me today; so we can resolve via a screenshare for you.
Laura
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------ - Audrey,
Did you figure this out?
Laura
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------Thanks very much. This worked!
------Original Message------
Audrey,
Did you figure this out?
Laura
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------- Sorry, I have been in meetings most of today. I will check it out tomorrow. Thanks
------------------------------
Audrey
------------------------------