ContributionsMost RecentMost LikesSolutionsRe: sync two related parent tables from a child tableThat did the trick! Thank you so much for taking the time to break down the formula! ------------------------------ SCOTT ALARCON ------------------------------ Re: sync two related parent tables from a child tableHey 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 ------------------------------ sync two related parent tables from a child tableHi 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 add a bill, the billing form correctly pulls up the related shipment, but not the related contact, even though on the shipment form the related contact is there. Is there a way to prefill both the related contact and related shipment fields so the data syncs to both tables without manually searching for the related contact? Thanks for any help! ------------------------------ SCOTT ------------------------------