Newbies silenuz Posted January 19, 2005 Newbies Share Posted January 19, 2005 I'm trying to develop a database of all my dvds, and am quite new to filemaker. I have a table for movies, and a table for actors, I have the layouts set etc..., but now what I need is a way to have a record in the actor table show related records from the movie table, as well as the movie table records having a portal with GTRR buttons to the actor table. From reading the forums I understand I need a join table, but how I go about this I have no real idea, other then records in each table must have unique ids , and the join table would be used for browsing etc... Any help, or suggestions would be greatly appreciated, I downloaded Ralphi's seperation model but don't really posess enough knowledge to decipher it. Also I ussed self-joins for year and genre and then a GTRR script to allow clicking on a year or genre and have related records brought up, everything works but what I was wondering when I went to vreate the second self-join I was prompted to create another table in addition to the one created for the first self-join. So what I was wondering is do I need both tables, or can I have both self joins to the same occurance of the first self-join table ? Thank you in advance. Link to comment Share on other sites More sharing options...
This topic is 6639 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