AnsweredAssumed Answered

Relational Database question (FileMaker starter)

Question asked by jr00n on Feb 19, 2014
Latest reply on Feb 20, 2014 by philmodjunk


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?