Create a single relation linking the Service column in the Quotes table to the Service column in the Services table. Then create a Lookup column that retrieves the price from that relation.
You may also want to change the column type to numeric for any columns that are going to contain numbers and be used for math.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.