Displaying related table in parent table

[MAINOH]

Hi,

I have a 2 tables:

tblREQ_LIST
tblREQ_DETAIL

Which I have a relationship set up for based on the REQ_ID.

I want to be able to open the tblREQ_LIST and hit a + sign on the record and have it show me the related records in tblREQ_DETAIL.

I've seen this in some of my other tables but have no idea how it happened.

thanks for your assistance.

 

[SgtJarrow]

This is formed when you go into the relationships window and create the relationship between the two tables.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[MAINOH]

thanks mstrmage1768!

I figured out that the type of join or perhaps it is rather the cascade update/delete is selected that makes all the difference.


when I changed the relationship to a simple outer join - it worked.

thanks!

 

[BlueHorizon]

Hi,

The plus sign represents a subdatasheet on the Insert menu. The default selection will be the related table. To remove a subdatasheet, go to Format menu, Subdatasheet.



Best,
Blue Horizon

http://www.bluehorizontraining.com