I am creating a form for a table (let’s call it Table A) which has fields linking to another table (table B) in the same base.
When filling out the field on the form on Table A, the user can only see the data in the primary field of Table B. However many of the records in Table B have similar primary field data making them difficult to distinguish. Being able to see one (or multiple) of the other fields would be really helpful.
For the time being, I’ve made the primary field on Table B a formula that merges the most helpful relevant fields from that table, but it makes all my Table B views very messy/ugly. I wish this formula could be in a non-primary field so I could hide it, but then my Table A form wouldn’t show it.
Please tell me there’s something stupidly easy I’m missing! Is there a way for a form to reference/show any thing BUT the primary data? Or is there a workaround I can use with another table?