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

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
------------------------------

Hi Gaurav - 

Have you considered utilizing Automations for this update, instead? Might be easier to set up.

For your formula above, is it a Formula URL button? If so, there are a few things you need:

1. You have this line in there twice: URLRoot() & "db/" &[_DBID_MONTHLY_TOTAL] & "?act=API_EDITRecord"&
2. You need to indicate the Record ID# of the parent you're editing (see line 4 below): "rid=" & URLEncode([Related Parent Field Name])
3. Include a redirect for where you want the user to land after the API call is made (see line 8 through 12 which will take them back to the child record)  with &rdr=
   
   

Your final formula would then end up like the below (where Related Parent Field Name is the numeric relationship field that holds the Record ID# of the parent record):

URLRoot()
& "db/"
& [_DBID_MONTHLY_TOTAL]
& "?act=API_EditRecord&rid="
& URLEncode([Related Parent Field Name])
& "&_fid_14="
& URLEncode([Date])
& "&rdr="
& URLEncode(URLRoot()
& "db/" & Dbid()
&"?a=dr&rid="
& [Record ID#])

------------------------------
Bree Mackey
------------------------------