When i say newbie... it's newbie as in Monday (4-16-12) is the first time I've opened the Access application. 11 Years in I/T, just never used Access before, I am impressed though, very slick db application.
Anyway, just wanted some clarification on something. My I/T manager installed SharePoint and created an access database using Microsoft's ' Assets Web Database' template, then handed the project off to me... lol. So I've imported the data from Excel that we needed into 'Assets' Table in the db and published the database to SharePoint. All is working well for the most part - I have another question pending in this forum, and I'll probably have more as I need to add some functionality to the db and have no VB experience whatsoever.
I don't understand why the form 'Main' which has two tabs that we use goes through so many dependencies to pull data from the table 'Assets'. Its like, on the form 'Main' on the 'Recon' tab it pulls data from the form 'AssetsCurrent' , the form 'AssetsCurrent' pulls data from the form 'AssetsDS' then the form 'AssetsDS' pull data from the query 'AssetsOpen' and assets open queries the table 'Assets'.
Is this because of the template we used or is it just the way that access pulls data from the table?
Main form Recon Tab -> AssetsCurrent form -> AssetsDS form -> AssetsOpen (Query)
Main form Recorded Tab -> AssetsRetired -> AssetsRetiredDS -> AssetsRetired (Query)
'