Jump to content

Creating sub-types


Beno
 Share

This topic is 6539 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6539 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.