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