Forum Discussion
Laura_Thacker
6 years agoQrew Captain
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
------------------------------
- AudreyBenenati6 years agoQrew CadetWhen I click the button on the parent record, it brings me to the child table's form, without the parent record info populated (there is a whole section of fields that should be populated on the child form, but they're all blank).
This new forum format is not allowing me to upload or paste any images.
------------------------------
Audrey
------------------------------- Laura_Thacker6 years agoQrew CaptainCan you post your formula...
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------ - Laura_Thacker6 years agoQrew CaptainYour formula should look something like this:
URLRoot() & "db/" & [_DBID_TABLENAME] & "?a=API_GenAddRecordForm&_fid_6=" & URLEncode ([Record ID#])& "&z=" & Rurl()
If it does not have the &_fid_xx= in it, then it is not encoding the related reference field with the key value of the parent table.
Delete the original Add button from the relationship window, and rebuild it. It will rebuild it in the default-format.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
- AudreyBenenati6 years agoQrew CadetHere is the formula for the button field.
URLRoot() & "db/" & [_DBID_ABSTRACTION] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl()
------------------------------
Audrey
------------------------------- Laura_Thacker6 years agoQrew CaptainAudrey,
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
------------------------------ - Laura_Thacker6 years agoQrew CaptainAudrey,
Did you figure this out?
Laura
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------- AudreyBenenati6 years agoQrew Cadet
Thanks very much. This worked!
------Original Message------
Audrey,
Did you figure this out?
Laura
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------