AnsweredAssumed Answered

Conditional Drop Down Data Schema Best Practices

Question asked by snardella on Feb 4, 2019
Latest reply on Feb 7, 2019 by snardella

Hi there,


I hope I'm not being repetitive by asking this question. I've set out to create conditional drop downs for NAMM codes (NAMM Product Categories | and I've been checking out some different methods for this. I was taught that data schema look like the images below from a DBMS agnostic point of view. After looking over some different methods with Filemaker, I've been seeing users create parallel duplicate tables in their schema as conditionals that are not are not related (see 3rd image). It was my understanding that each table in the database should be related however it seems like that's not so with Filemaker. Could anyone shed any light on best practices for schema design for conditional drop downs? Thank you!





Screen Shot 2019-02-04 at 4.14.03 PM.pngIMG_1186.jpgScreen Shot 2019-02-04 at 4.26.49 PM.png