Table within a Table?

[Hacktastic]

I saw this in a database i recently took over and never saw it before....

Its a TABLE of Names with Ids, which links to another table of IDs to Sales Accounts....

Thing is, within the table view of Names has a + sign in the beginning of the row, once i click on that, it shows me the linked values in SALES Accounts for that Id

wow...how did he do this??? Its pretty nifty trick.

 

[MajP]

http://vb123.com/toolshed/00_access/subdatasheet.htm

http://office.microsoft.com/en-us/access/CH063645611033.aspx

google subdatasheets

 

[Hacktastic]

u rock, thanks

 

[dhookom]

Many of us veteran developers have a little code that loops through all of the tables and sets the subdatasheet property to "none". Generally, you don't want to expose your users to table datasheet views. I also believe the subdatasheets hinder performance.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Agree, especially with Acess 2000 and a split database. These subdatasheets can bring your db to a screeching halt.