I have worked with SQL databases in the past but am having trouble wrapping my head around how to work with databases in Notion.
One of my hobbies is colouring so I have a table (database?) that lists my different sets of pencil crayons. I want each item (set) to link to another table that lists the info for each pencil in that set (number, colour name, etc.)
When I create a page for a picture that I am colouring I would like to display a table of the colours that I used on that picture pulled from the pencils table(s). I may use pencils from several different sets (brands).
I can't seem to figure out how to pull specific items (records) from one or multiple databases and display them in a single table.