Relational Database question (FileMaker starter)
Hi, i'm not new to databases but instead new to FMP.
I'm setting up a database with a structure like a Cars database. See picture for relations defined.
When i add a new car i want to choose a brand (all brands are shown) and then a type (only types from that chosen brand must be shown in drop-down). But wat is the brand field on my Cars form? I don't need a foreign key for the brand i think, because when i have a foreign key for the type i know the brand via the relation...or do i some thing wrong?