Database structure (Airtable)

Hi all,

I am working on a CRM system and am using Airtable to create a database. In a brief summary the structure of the database looks like this:

  • customer
  • projects (an unlimited number of tasks can be created for a client)
  • tasks in the project.

The projects are always standardized and have a certain number of tasks.

For example:

  • Project A…
  • … contains 5 tasks that need to be done in a certain order. The user of the system should be able to mark individual steps as completed.

Question: How best to make a base in Airtable data for such a data structure?