Skip to main content
Question

1 to 1 Relationship

  • March 22, 2017
  • 0 replies
  • 80 views
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. Dell Computer Serial Number 1234, Dell Computer Serial Number 1235 etc.

An Equipment record can only be associated with a single Order but an Order can have many Equipment.  (The current relationship is that an Order can have many Equipment.)  But.. the Equipment table should be static data, the user should not have to create an Equipment record each time they are creating an Order record. Rather than Add an Equipment record from the Order page i'd like to link or relate an Equipment record with an Order, is this possible?
      This topic has been closed for replies.

      • EricJHansen
      • Registered
      • March 22, 2017
      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!
      Terms & ConditionsAccessibility statement