June 20, 200619 yr 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.
June 21, 200619 yr 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
Create an account or sign in to comment