Nemo Posted June 20, 2006 Share Posted June 20, 2006 I've went through and read all the posts i could find relating to portal sorting/filtering but i am still am having an issue. The issue being: I have a portal wich displays all the records in my "contractor" table. I have another table "FP" wich has info regarding our jobs. These two tables are related by a field called "recordID" in each respectivly. There are mutltiple "contractor" records, for every one "FP" record. The "Contractor" records that correspond to the "FP" record share the same "recordID". I need the portal to display only the records that have a "recordID" that corresponds to the "FP" record Im on. Sorry if this sounds a bit convaluted, but this has had me stumped. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted June 21, 2006 Share Posted June 21, 2006 Might it be because you mix up tables and table occurences?? Just relate the main TO with an extra TO of your childrecords, with the required field. --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6512 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 accountSign in
Already have an account? Sign in here.
Sign In Now