Relationships between tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)



LHSCMRB said:
When I have a relationship between Table A and Table B, the '+' to the
Click to expand...
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
Click to expand...
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
Click to expand...
Tables B & C? (In both cases, it is a one to many relationship, with Table
A being the one)
 
Back
Top