Gabe Posted January 22, 2005 Share Posted January 22, 2005 Hey guys, I've just started using filemaker, I'm coming from a web database programming background. I understand relationships and all that stuff, but I am still coming to terms with how FM deals with them. I have a simple setup so far. Im keeping track of a set of lawsuits. I have a suits table and a parties table. I have a join table linking them, with a field for the suit id and the party id. I also have a field in the join table telling whether the party is a plaintiff or a defendant. On the layout for the suits table I added a portal to pull a list of the parties involved. I added the field in the join table for partytype, but in all of the rows it only shows the value of the first join record. In parties, I have: 1 John 2 Henry In suits 1 lawsuit Then I have PartiesInSuit: 1 1 Plaintiff 2 1 Defendant THe portal shows John Plaintiff Henry Plaintiff If I change the field next to Henry to Defendant, it changes the record for John in the join table. I guess I don't have it set up right. Parties can be involved in multiple suits, so I cant add the partytype in the parties table itself. WHy is it behaving this way? Link to comment Share on other sites More sharing options...
This topic is 6624 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