Hi, I am evaluating airtable for use in our not for profit orgainisation and I’m struggling with the correct structure to start.
I have three tables:
Table Name: Trainee
Field: Trainee ID (Primary Key), Name, Address
Table Name: Courses
Field: Course ID (Primary Key), Trainee ID (Foreign Key to Trainee ID ), Course name, Course Passed
Table Name: Work History
Fields: Work ID, Trainee ID (Foreign Key to Trainee ID Table), Employment Gained, Start Date
I want to be able to use the linking to run reports such as number of trainees who have passed or even of the trainees who passed how many went on to gain employment. I don’t seem to be able to link specific columns in tables. Also, if you create a form, can you have columns on the form from across different tables?