AnsweredAssumed Answered

Database views - FP12 database design question

Question asked by MichaelFlynn on Aug 18, 2013
Latest reply on Aug 18, 2013 by GuyStevens


Database views - FP12 database design question


     Sorry for the noob question but I'm starting out with FP12 for a given project and I'm struggling with a design issue.

     As it stands, I'd like a single table to contain fairly related information, and then create a view (such as found in Oracle, DB2, SQL server) to display only certain values.

     For instance I want to have a karate master table that contains techniques for weapons, such as clubs, knives, and guns.  I'd like to create a view that only shows the club techniques.  So when I use my iPad, I can just show the club techniques, or gun techniques, etc.  

     Right now I have about 6 different tables housing various technique types which isn't bad but I'd like to see if I can do this better.  Any suggestions?  I come from a Oracle, DB2, SQL Server background and I think my knowledge set with materialized views and queries is hindering the design as FileMaker is a different animal

     Thanks in advance