I am expecting this is more or less obvious, but I can't figure out how to solve it at the moment.
How I built it so far
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
"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.
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.