I'll go through the steps that I did.
I have an app with 2 tables, one with static data with mail costings and one with dynamic data where we key customer information and provide quotes.
I created a relationship between them based on many quotes to one cost line.
QuickBase then added additional fields in my quotes table with the drop down of the field I want to use as a reference.
In the quote process we build the reference up based on weight, volume etc and this will match a value in the costs table.
I have the quote sting built in a field.
The dropdown in the form works and pulls back the correct cost, but instead of using the dropdown manually I would like to push a value from a field which has the correct string to use. In SQL terms this would be
SELECT cost1, cost2 FROM costs WHERE costs.ref = quote.ref AND quote.ref = "mystring"
The dropdown contains the costs.ref values.
Is it unusual for QuickBase as part of the relationship build that additional fields are created?
