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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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