gauravtugnayat
6 years agoQrew Member
How to relate date filed from child table to date field from parent table
Hi All,
I am working on a application in QB. their are two tables named "SLA Region" and "SLA Monthly Total". The first table has region wise record and the second table has total of 30 days. Both the table are related with each other. "SLA Region" is child table and "SLA Monthly total" is parent table.
I just want to get the date from "SLA Region" table and reflect it on "SLA Monthly Total" table. How can I do that. I tried making it lookup field but it does not work and also I tried to use the below formula.
URLRoot() & "db/" &[_DBID_Table name] & "?act=API_EDITRecord"URLRoot() & "db/" &[_DBID_MONTHLY_TOTAL] & "?act=API_EDITRecord"& "&apptoken= Application token"& "&_fid_14=" & URLEncode([field name of child table])& "&disprec=1")
Can some please help me get the expected result.
------------------------------
Gaurav Tugnayat
------------------------------
I am working on a application in QB. their are two tables named "SLA Region" and "SLA Monthly Total". The first table has region wise record and the second table has total of 30 days. Both the table are related with each other. "SLA Region" is child table and "SLA Monthly total" is parent table.
I just want to get the date from "SLA Region" table and reflect it on "SLA Monthly Total" table. How can I do that. I tried making it lookup field but it does not work and also I tried to use the below formula.
URLRoot() & "db/" &[_DBID_Table name] & "?act=API_EDITRecord"URLRoot() & "db/" &[_DBID_MONTHLY_TOTAL] & "?act=API_EDITRecord"& "&apptoken= Application token"& "&_fid_14=" & URLEncode([field name of child table])& "&disprec=1")
Can some please help me get the expected result.
------------------------------
Gaurav Tugnayat
------------------------------