AnsweredAssumed Answered

Subsets of Tables?

Question asked by on Feb 27, 2015
Latest reply on Feb 27, 2015 by


Subsets of Tables?


Hi- I come from an object oriented programming background but haven't been programming in 10 years. I got FM about 1 year ago and created simple databases and relationships, which has worked well but I want to increase functionality. I am not sure what the correct terminology is to use, so I will do my best!

My question is how do I create a table that is a subset of an existing table. For example, I have Table A that has 10 fields in it. I want to define a table that has the same entries, but 3 of the fields aren't used.

I guess another way to look at this is a parent-child relationship. The parent has 7 fields, a child has the same 7 plus 3 more.

What is the best practice in FM?  Could I use a match field to identify the table as a child of the parent, or a type of a table? Any insight would be appreciated!!! I find that I get confused between FM and actual code writing, if that makes sense...