Selecting from detailed list?

Ask for Help
1

Table A has a one-to-one relation to Table B. When editing an item in Table A, the user has to see several column values from Table B in order to chose the right item from Table B.

I have tried showing the items from Table B in a list, but the action Set column values does not have an option to set column values in Table A.

How can I solve this other than concatenating column values and show them in a choice component?

Thanks!

2

Create a single relation from TableB back to TableA. Then you can set column values through the relation.

2 Likes
3

Thanks for your reply. Unfortunately each item in Table B can be related to more than one item in Table A. It’s a one-to-many relationship from Table B to Table A but I don’t know how to set that up.

4

So are you saying that you need to set values in multiple rows in table B with a single action?
If that’s the case, you would need to use a workflow for that.

Would you mind sharing screenshots of both tables, so that we can get a better visualisation of what you have and what you are trying to do. I’ve read your question multiple times, but I’m still not sure I’m clear what the actual goal is.

3 Likes
5

Hi! I don’t want to share the actual table data but I’ll try to explain myself better. I don’t think my need is unique; the problem is probably that I haven’t understood my own need.

For a column in Table A, I want to be able to point to a row in Table B. I can easily do this with a choice component. The problem with a choice component is that it only displays a single column value to the user. That’s not enough in my case - the user needs to see multiple column values to be able to choose correctly. My solution has therefore been to, in the edit view for Table A, display all rows in Table B in a list that shows multiple column values. The problem arises when I need to save the row from Table B that the user selects. I can’t seem to save the user’s choice in Table A since the screen has lost it’s reference to Table A.

I have attached a screenshot of a simplified mock up of my data. I have probably set it up incorrectly. The reality is that each row in Table A is only related to one row in Table B, but each row in Table B can be related to multiple rows in Table A.

Tables
Tables865Ă—218 12.8 KB

6

Okay, that’s a bit clearer.

Perhaps you could do something like the following:

  • Add a RowID column to Table A, if you don’t already have one.
  • When a User views a record in Table A, write the corresponding RowID value to a column in the User Profile row.
  • Use that to build a (single) query from Table B back to Table A using that RowID value as a filter
  • You should then be able to Set Column Values in Table A from Table B via that Query
3 Likes
7

Can you just have a template column to join column values in table B together to use as the “display as” value for table B?

2 Likes