Forum Discussion

SCOTTALARCON's avatar
SCOTTALARCON
Qrew Member
6 years ago

sync two related parent tables from a child table

Hi there, Here is the relationship of the tables: Contacts has many shipments Contacts has many billings Shipments has many billings Scenario: If I am looking at a shipment and want to...
APIs and custom code
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
no problem,
but can you post the current code to Add Bill, when sitting on a Shipment, and let me know the fid# of the field to be populated which is probably called [Related Contact]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
SCOTTALARCON's avatar
SCOTTALARCON
Qrew Member
6 years ago
Hey Mark, thanks for the reply.  I've attached a couple screen shots to clarify.  Basically when I'm on the shipment form, because the table is related with billing it automatically has a 'add bill' button. But the default code behind it is: 
URLRoot() & "db/" & [_DBID_TABLE_4] & "?a=API_GenAddRecordForm&_fid_48=" & URLEncode ([Record ID#])& "&z=" & Rurl()
When I click the button, the billing form only pulls up the related shipment.  The shipment is also related to the contact. (now patient as I've changed it), so I'm trying to get the 3rd table, billing, to know both the related patient and related shipment when a new bill is created from the shipment form.  Is this possible? 
Thanks.


------------------------------
SCOTT ALARCON
------------------------------