Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

quote:

Originally posted by richshone:

I have been designing an application for the music industry that allows all information necessary for artists touring around the world to be accessible in useful ways. So far I have been doing this with the intention of it being a separate file created for each artist (mostly because I originally designed it my personal use). At this point I am attempting to modify this to a multiple artist database so a management company can have all of their artists records in one file (with access privleges assigned for each artists' representatives). All of this is no problem except for one thing - I had originally created a contacts layout, listing important addresses/numbers related to the artist using global fields so they could be typed in once only. How should I modify these fields so they can be 'globally related' to a particular set of records and then have another set that is 'globally related' to another (all defined by "artist")? Do I need to use a calculation field of some sort (what would the calcualation be?) or is there a relational global function that will do this for me? Much appreciated for any advice...

Globals are global per file. You would be best served by setting up a "Contacts" database which contains this information.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Posted

I have been designing an application for the music industry that allows all information necessary for artists touring around the world to be accessible in useful ways. So far I have been doing this with the intention of it being a separate file created for each artist (mostly because I originally designed it my personal use). At this point I am attempting to modify this to a multiple artist database so a management company can have all of their artists records in one file (with access privleges assigned for each artists' representatives). All of this is no problem except for one thing - I had originally created a contacts layout, listing important addresses/numbers related to the artist using global fields so they could be typed in once only. How should I modify these fields so they can be 'globally related' to a particular set of records and then have another set that is 'globally related' to another (all defined by "artist")? Do I need to use a calculation field of some sort (what would the calcualation be?) or is there a relational global function that will do this for me? Much appreciated for any advice...

This topic is 8854 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
×
×
  • Create New...

Important Information

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