Good afternoon (UK). I’ve just signed up for a year of Pro.
I am surveyor dealing with commercial property and much of work overlaps with that of a lawyer.
I’m not new to database design, having been using Filemaker for years (but only in flat form, not relational). Currently I use Clio (law practice but I’m finding it slows me up) and a combination of Devonthink Pro 3 and Scrivener for my law library.
I am planning on using AirTable for my law library and for task management (client contacts, etc, property info, etc. I have added a couple of templates to get a rough idea.
I have 2 questions.
Would it be better to have a separate base for my law library or does it matter if one base contains dozens of tables?
Where a field is for a person’s name, is it better to have two fields, one for first name, the other for surname, or one field only.