carlyle Posted January 28, 2005 Share Posted January 28, 2005 I am wondering if there is a way to display data in one file from a file that is 2 or more relationships away. For example, I have 4 files: PEOPLE(storing contact information about the various film makers, distributors, etc who are associated with each film) LODGING (storing information about where people are staying while they're here) FILMS (storing information about film--name, length, description, etc.) SHOWINGS (storing information about the times, places, and dates that each film will be shown) They are linked as follows: LODGINGS=by person ID to=PEOPLE (one to many, since each person may have more than one lodging) PEOPLE=by person ID to= LINK FILE(which creates a many to many relationship between people and films, since one person may have several films, and one film has several people associated with it--directors, actors, etc) LINK FILE=by Film ID to=FILMS FILMs=by Film ID to=SHOWINGS (since each film may be shown more than once) The problem is that I would like to be able to display the information on any given person's films (INCLUDING the information about where and when it will be showing...from the "showings" database) in the PEOPLE database (and preferably in the lodgings database too...) Is there a way??? Hmmm...at this point I should probably mention that I am using ancient version 4 of FileMaker . I'd love to find a way to do this in version 4, but I'd also be interested in hearing if there are ways to do it if I (gasp) upgrade... Thanks in advance... Carlyle Link to comment Share on other sites More sharing options...
This topic is 6627 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
Already have an account? Sign in here.Sign In Now