I have two tables (Table A and Table B) linked to a common table (Table C).When adding a new linked Table C record from Table A or B:I want Table A to use View 1 from Table C.I want Table B to use View 2 from Table C.View 1 and View 2 have two differ...
I want to use a different view when I manually create a new linked record from another table. Currently, when adding a linked record, the first view is always used. Is there any way I can change that?
Thank you very much for your detailed answer.I am leaning towards your last paragraph. I don't want both tables to default to whatever View is in the topmost. I want each table to use a different view not just the topmost. Is there a work around for...