mjhnson24 Posted June 7, 2012 Share Posted June 7, 2012 I have a table Customer Scripts. There can be multiple script records for each Client ID. Lets say theres 7 records for Client ID 6070. each script record has multiple paragraph records displayed in a portal related to customer scripts through a join table via paragraph ID and CustomerScript ID. So any one of the 7 customer script records could have the same paragraph in them just related to that customer script ID also. I have a layout that is relating to that join table via client ID (I capture the client ID and add it to the join table record as each paragraph is added to the customer script record just in case i need it), so the each of the 7 scripts could be using Paragraph ID SP4612 so the portal would be showing 7 records in it just for that paragraph id since its related via client id. How do i filter that portal to only show one copy of that SP4612 paragraph ID? I only need one to show in the list so they can choose it if needed to add to a new script record. Keep in mind that i do have a current filter on that portal that allows me to type into a field and filter the portal even further with the records being shown so i can Type SP4612 in that field and only the record for SP4612 will show. That filter script is below. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.