1 to 1 Relationship

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Ringoparr

Ringoparr

  • 844 Points 500 badge 2x thumb
  • Tepid

Posted 2 years ago

  • 0
  • 2

There are no replies.