Referencing another table

Good Morning.

I was just looking for a wee bit of help and knowledge.
I am planning a quite simple database CRUD I suppose with members.
I’m not sure whether it’s best to use the built in Postgres database or gsheets.
Next question I have lists of places and titles I have in other 2 tables and would like to reference them with id keys etc. would there be any tutorials available to do this sort of thing. Don’t need anything fancy just a system for myself. Probably also a form to enter new details.
Thanks so much for any help.

Hello @alanfallow !

I think a very simple Postgres DB (you can use RetoolDB internally for this) which references foriegn keys would be what you want to start with.

This tutorial doc should help you see how to start linking to other tables.

1 Like

Thank you will have a go.