1 to 1 Relationship
Can Quickbase support a 1 to 1 relationship? I have an application that consists of 2 tables, Orders and Equipment. Orders are created by hand while Equipment is a predefined list of records i.e. ...
Forum Discussion
What you would usually do here is have an orders table, and equipment table, and a line items table, where an order can have many line items, an equipment item can have many line items.
From there you can add a quantity field to the line item record, and a total field that takes the base equipment price multiplied by the quantity.
Delete your existing orders to equipment relationship and give the above a shot. it is the standard way of handling what you are describing.
good luck!
From there you can add a quantity field to the line item record, and a total field that takes the base equipment price multiplied by the quantity.
Delete your existing orders to equipment relationship and give the above a shot. it is the standard way of handling what you are describing.
good luck!
That did it, you nailed it. Thank you Eric!