I have a quote program which assigns a master JT# for each project. Each estimate associated with that JT # receives an SL Est #. If a JT# has multiple SL Est #'s associated with it, each SL Est # starts with the same 6 digits (i.e. 248168 in attached .jpg) and then A, B, C, D depending on how many estimates are sent out for that same JT #.
Per the attached (.jpg), I would like to be able to run an update query to update SL Est #248168F with the JT # 14150 as has already been done manually for 248168D and 248168E.
I have to do it this way, because I am importing the estimate table into the JT# table. Once I manually join the first estimate (i.e. 248168A) with JT 14150, I want to run the update query to update the JT# field based on just the 248168 prime number, but I don't know how to do that in a query.
Any suggestions? Thank you
Mark
Per the attached (.jpg), I would like to be able to run an update query to update SL Est #248168F with the JT # 14150 as has already been done manually for 248168D and 248168E.
I have to do it this way, because I am importing the estimate table into the JT# table. Once I manually join the first estimate (i.e. 248168A) with JT 14150, I want to run the update query to update the JT# field based on just the 248168 prime number, but I don't know how to do that in a query.
Any suggestions? Thank you
Mark