Slobey Posted November 4, 2004 Share Posted November 4, 2004 Hi, I need help. I have a Solution with a job table and a line item table. Each line item has an option field in it. I have a layout with a portal that shows only the line items for the options that I have written in the Job files option field (which is on the layout. This is through a multiple relationship between the two tables (job id and option must match. What I am trying to do is instead of having to write in the options I want to view, I want to have a list on the Job file layout that shows all the Options for that job as a list and allows me to check off the ones I would like included. Is there a way to do this automatically? I hope I am not confusing anyone else as much as I am confusing myself. I know this can be done, please help. thanks Link to comment Share on other sites More sharing options...
transpower Posted November 5, 2004 Share Posted November 5, 2004 Try a checkbox field. Link to comment Share on other sites More sharing options...
Slobey Posted November 5, 2004 Author Share Posted November 5, 2004 Thanks for your reply The check box is what I am trying to do. But the checkbox list doesn't show all the options, because the relationship depends on the option matching. So I have to manually enter the options for it to show up. I want a list of ALL the options and then use the check box to select the ones I want to display. Does that make sense? Link to comment Share on other sites More sharing options...
-Queue- Posted November 5, 2004 Share Posted November 5, 2004 Create another relationship to Line Items based on only job id. Then create a value list of options based on this relationship, starting from the current table. Link to comment Share on other sites More sharing options...
Slobey Posted November 9, 2004 Author Share Posted November 9, 2004 OK, I have created a value list. Now how do I display it and allow the user to click on which ones he wants to see? Thanks I really appreciate all the help guys Link to comment Share on other sites More sharing options...
-Queue- Posted November 9, 2004 Share Posted November 9, 2004 Format your field as a checkbox, using the newly created value list. Link to comment Share on other sites More sharing options...
Slobey Posted November 9, 2004 Author Share Posted November 9, 2004 I did that, and I can check them off. What I am hoping is that when I check a box, it will automatically display only the related items. Link to comment Share on other sites More sharing options...
-Queue- Posted November 9, 2004 Share Posted November 9, 2004 If your relationship is multi-criteria based on JobID and this option field, selecting/deselecting options should make them appear/disappear in the portal. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7079 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