Forum Discussion
MarkShnier__You
Qrew Legend
I'm trying to understand your question. You have a parent and say 20 children. When you say that you want to pull a field form the children, which of the 20 record do you want to pull a value from?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
BarbaraAlvarez1
3 years agoQrew Member
Sequence is ...
select and save an agency
then add Type-A record(s) to the agency
then add a Type-B record to the agency
I then can print the form.
The exact form then shows the agency,
and the Type-A report grid
and the Type-B report grid.
Then I build a small table in the form that needs to populate a column with a field value from the Type-B record(report) - Client name. So I need the client name related to the Agency record save. Hope that is understandable.
------------------------------
Barbara Alvarez
------------------------------
select and save an agency
then add Type-A record(s) to the agency
then add a Type-B record to the agency
I then can print the form.
The exact form then shows the agency,
and the Type-A report grid
and the Type-B report grid.
Then I build a small table in the form that needs to populate a column with a field value from the Type-B record(report) - Client name. So I need the client name related to the Agency record save. Hope that is understandable.
------------------------------
Barbara Alvarez
------------------------------
- MarkShnier__You3 years agoQrew LegendOK, so this is not an exact forms issue. The issue is how to float up some data form a child table into a clean field on the parent record. Then the Exact form is easy as you have a clean field to use.
I'm not sure I fully understand what your form and relationships look like, but I suggest making editing the relationship to create a combined text summary field of the Client Name.
Then make a new field with the formula
ToText([Client name])
and use that field on the Exact Form.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------