Jump to content
Sign in to follow this  
Slobey

Separated List

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Format your field as a checkbox, using the newly created value list.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

If your relationship is multi-criteria based on JobID and this option field, selecting/deselecting options should make them appear/disappear in the portal.

Share this post


Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.