I’m making my first database in Base and I have a little problem.
Imagine this database:
Table: Employee
ID:1
Name:John
OccupationID:1
ID:2
Name:Clara
OccupationID:2
ID:3
Name:Simon
OccupationID:3
Table: Occupation
ID: 1
Name: TroubleMaker
Salay: 500k
ID: 2
Name: ProblemSolver
Salary: 1200k
ID: 3
Name: TimeWaster
Salary: 3600k
I’d like to be able to add new Employees to the database, but instead of typing manually OccupationID
numbers into the fields, I’d want to have a drop down menu where I can select “Trouble maker”, “Problem solver” or “Time waster”.
Otherwise putting the data into the Employee
table will require me to constantly look up other tables, and it’s really not practical.
I’m sure there’s a way to solve this problem, but I’m fairly new to this software.