Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 20, 2022 01:02 PM
Dear Community,
I am expecting this is more or less obvious, but I can't figure out how to solve it at the moment.
Mission Statement
How I built it so far
My challenges
Dec 20, 2022 10:07 PM
You should have a linked field between Table A and Table B, right? If that exists, you can add that to the form in Table B and users will be able to select the record from Table A that they're keying in data for
In Table A, you'd add lookup/rollup fields to display the data from Table B as needed
Dec 21, 2022 12:44 AM
"In Table A, you'd add lookup/rollup fields to display the data from Table B as needed"
That is my exact issue. In Table B I have a "Link to another Record" field, which is also the form input for the user to choose the Record from.
However, how to reference in Table A? Table A still has no "link" and therefore does not allow me to add a lookup or rollup field.
Dec 21, 2022 03:39 AM
Odd. If you've got a linked field in Table B to Table A, then both tables are linked to each other. Could you share some screenshots of both tables?
Dec 21, 2022 03:47 AM
Thank you, I just got it. I did not understand until now that creating a "Link to another Record" field in Table B, there is automatically a linked field created in Table A. Just found and used it. Thanks.