Relationships between tables

[LHSCMRB]

When I have a relationship between Table A and Table B, the '+' to the left of the records is awesome. It allows me to see info from the other table and enter info into the other table.

Once I add a relationship between Table A and Table C, the '+' button to the left of records in Table A disappears, which is where I need it the most.

Is there any way to bring that button back and show linked info from Tables B & C? (In both cases, it is a one to many relationship, with Table A being the one)

 

[Van T. Dinh]

Check Access Help on how to show SubDatasheet. You can only show either
Table B or Table C as the SubDatasheet of Table A (in DatasheetView) but NOT
both at the same time.

--
HTH
Van T. Dinh
MVP (Access)

When I have a relationship between Table A and Table B, the '+' to the

left of the records is awesome. It allows me to see info from the other
table and enter info into the other table.

Once I add a relationship between Table A and Table C, the '+' button to

the left of records in Table A disappears, which is where I need it the
most.

Is there any way to bring that button back and show linked info from

Tables B & C? (In both cases, it is a one to many relationship, with Table
A being the one)