Gabe Posted February 2, 2005 Share Posted February 2, 2005 Does anyone know how I should set up a relationship that will allow me to display only specific related data? I have a many to many relationship with a join table linking to master tables. Within the join table I have a field describing the type of relationship, and a sequence field which sets which records have priority over the others in the same relationship. On the main display, I want to show two records with the two different possible relationship types. For example, in my system, I have a lawsuits table and a parties table. Linking them is a table which contains which parties belong to which suits, along with whether they are a plaintiff or a defendant. On the lawsuits layout, I want to display the name of the first plaintiff and the first defendant, but only one of each, even though there can be multiple plaintiffs and defendants. Right now I have a sequence field which prioritizes the parties, with a value of 1 signifying the primary plaintiff and defendant. I can't figure out how to use those two fields, the type and the sequence, to reference the particular records I am looking for. can anyone help? 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