ContributionsMost RecentMost LikesSolutionsRe: pipelines update parent record from child record Thank you both. I'll give that a try as well. ------------------------------ Nic M ------------------------------ pipelines update parent record from child record hello, I have two tables. parent named location has a field serial number child named equipment also has a field new serial number they are related by parent - Record #ID with a text reference proxy "location ID" to the child. the trigger is set so when i create / change a child record and i fill in "set" a new serial number I would like the parent serial number updated to serial number in the child.. I have tried many options I can't seem to find out how to push the new serial number from the child to the serial number field in the parent table. thx -N ------------------------------ Nic M ------------------------------ Re: snapshot of field with condtion Ah. now I understand. thank you! -N ------------------------------ Nic M ------------------------------ Re: snapshot of field with condtion thank you for the reply. I wasn't clear in the question. I have a snap shot field in the child form called serial number. serial number comes form the parent form/ field of the same name. i would like the snapshot to take place only when I select a child form / field called "service" and select remove/replace. thx -N ------------------------------ Nic M ------------------------------ snapshot of field with condtion I have a field on child form i would like to snap shot from a parent form, but only when the child record is created when a specific (drop down) field is set to a condition. is that possible? ------------------------------ Nic M ------------------------------ parent to child table snapshot of field based upon text selection and update of parent hello, I'm trying to archive a field from a parent table to a child table. then update the parent table. I have a parent table. "device_location" (key is record ID) and a child table of "service" related to parent by Numeric (reference) proxy field of "device location name" the parent table also contains a lookup to a master table of device serial numbers. A device serial number is placed at a location in the parent device_location table. occasionally a device needs to be removed and replaced in the service table. when creating a service record I will select a service action from a drop down list. the service is called R&R (remove and replace). I would like to have the child table retain (snapshot?) the old serial number from the parent table (based upon R&R selection) and then have a field for the "new serial" to be entered and have that update the parent table. not sure if this can be done? and this may not be the most clear way to ask? thank you -N ------------------------------ Nic M ------------------------------ Re: sub-form to update main form field and retain old info I am thinking a snapshot of a lookup field may work? ------------------------------ Nic M ------------------------------ sub-form to update main form field and retain old info hello, I have a form named installations that tracks equipment installed on utility poles by site name. e.g. serial number 123456 installed at site name B234 the serial number is a lookup to an equipment table. I have a sub-form / table called service that tracks the number of visits to a utility pole associated to the site name. service has only a few options. audit, troubleshooting, repair request and remove and replace. when choosing remove and replace, i would like the sub form to show the currently installed serial number and provide a lookup to the equipment table for a new serial number. when a new serial number is entered, I'd like to have the old serial number remain in the sub-from / table and have the newly entered serial number populate the installation form/ table with the new serial number... can this be done? thx -N ------------------------------ Nic M ------------------------------ Re: text dropdown list to call secondary listPerfect! thank you! ------------------------------ Nic M ------------------------------ text dropdown list to call secondary listHello All, New to QB and the forums. been searching and more than likely I am not asking the correct question, so here it goes. I have a table with a drop down list with three choices. "inspected", "approved" and "rejected" (these options are a separate table and related to the parent table "surveys") If "rejected" is chosen, I would like a secondary list to show or become available with a secondary list of choices of "permitting", "safety-1" or "safety-2" if this has been posted, please provide a link? thank you -N ------------------------------ Nicholas Marinella ------------------------------