Beno Posted February 27, 2004 Share Posted February 27, 2004 Hi everybody ! I'm wondering how it is possible to create subtypes with FileMaker. For example, let's say I have a file clients, but I want to create a distiction between private and professional clients, which have different properties and heritates from the common properties of clients. I would thus like to obtain 3 files : clients, clientspro and clientspriv, the two last being subtypes of the first one. And I still need the file clients, if i have clients that do not match both subtypes. I'm waiting for your help ;o) Tanks a lot Link to comment Share on other sites More sharing options...
CyborgSam Posted February 28, 2004 Share Posted February 28, 2004 Benoit-> One solution which is what you described: In the Clients file, I'd define a field with values that differentiate whether the client is private, professional, etc. It could be a text field, number field, etc. The key field in Clinets is a number SubFile.RecID. In each sub file I'd have a unique key field called RecID, it is auto-entered with a serial number. The Clients file then has relationships from SubFile.RecID to each sub file's RecID. Is the info for the non-matching clients the same as some of the info for the private/professional? If so, then all that info stays in Clients. if not, I'd create a third sub file so Clients doesn't have empty data for the two sub types. Link to comment Share on other sites More sharing options...
Beno Posted March 2, 2004 Author Share Posted March 2, 2004 Ok. Thanks a lot Link to comment Share on other sites More sharing options...
bruceR Posted March 3, 2004 Share Posted March 3, 2004 Beno Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7354 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now