Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Relational Database & Forms

Topic Labels: Base design
122 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi !

I’d like to create a relational database with contracts like this :

  • many contracts (contract 1, contract 2, contract 3, etc.)
  • many contracts types (type 1, type 2, type 3, etc.)
  • many attributes (attribute 1, attribute 2, attribute 3, etc.)
  • each contract has only one contract type
  • each contract type has a strict list of attributes (type 1: attribute 1, attribute, 2, etc. ; type 2: attribute 2, attribute 3, etc.)
  • each attribute has a value

At the end, 1 contract has only 1 contract type with a strict list of attributes that I want my users to fill the value.

I’d like to create a database structure that allow my users to create a new create with a form like this :

  • select a contract type
  • see all related attributes
  • fill the value for each attribute
  • create the contract record

What is the most relevant & efficient database structure ?

Many thanks !

0 Replies 0