Forum Discussion

gauravtugnayat's avatar
gauravtugnayat
Qrew Member
5 years ago

How to relate Date filed from child table to Date field from parent table

Hi All, I need help in one of my QB application. Their are two tables in which I build relationship and I want a field from Child table should update automatically a field in parent table when child ...
Relationships
KirkTrachy1's avatar
KirkTrachy1
Qrew Assistant Captain
Hi Gaurav: 

If you want the date field of the child table to go up and change a field on the parent table, you could do it with an automation.

See Video:
https://www.youtube.com/watch?v=fgwAiRuWnCI

You could also create a summary field that looks at the child date field of all the child records and gives you the MAX Child Date.

------------------------------
Kirk Trachy
------------------------------
LoydaCampos1's avatar
LoydaCampos1
Qrew Member
4 years ago
Hi Kirk:

Can you please explain the summary field option? I'd rather do it that way, but I'm not sure how, because I think a summary field only allows you to select numeric fields, apart from counting related records.

Thanks,

------------------------------
Loyda Campos
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    Loyda
    re: because I think a summary field only allows you to select numeric fields

    Actually you can do a Minimum or Maximum Summary on a Date field type or a Date / Time field type.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • LoydaCampos1's avatar
      LoydaCampos1
      Qrew Member
      4 years ago
      Hi, Mark.

      I see my error. I was trying to change the parameters of an existing summary field (Numeric, obviously), but the option of chose a date field is only available when you create a new summary field.


      ------------------------------
      Loyda Campos
      ------------------------------