K
Karen.Reedy
I'm quickly getting past the (limited) amount of knowledge that I have of
Access, so I have to first ask if this is even possible. Here's the
situation:
Database set up to track store profile and remodel information.
TblStoreInfo carries address and basic stuff like that. PK is store # so
that there is only one record per store. TblRemodelInfo carries all the
particulars about a remodel. PK is RemodelID# because one store can have
many remodels. Joined one-to-many. FrmStoreInfo is tabbed - first tab is a
regular form sourced from TblStoreInfo. Subsequent tabs are meant to display
various aspects of individual remodels and display subforms that populate
from TblRemodelInfo records for a given store. If a store has 3 remodels,
for example, it will have 3 records in each of the subforms.
My question is - is it possible to link the subforms so that as you advance
through the records in the subform on the Remodel tab, that you also advance
through the records on the other tabs as well so you're always looking at
data for the same remodel from tab to tab? Or, is there a better way to
structure this?
Access, so I have to first ask if this is even possible. Here's the
situation:
Database set up to track store profile and remodel information.
TblStoreInfo carries address and basic stuff like that. PK is store # so
that there is only one record per store. TblRemodelInfo carries all the
particulars about a remodel. PK is RemodelID# because one store can have
many remodels. Joined one-to-many. FrmStoreInfo is tabbed - first tab is a
regular form sourced from TblStoreInfo. Subsequent tabs are meant to display
various aspects of individual remodels and display subforms that populate
from TblRemodelInfo records for a given store. If a store has 3 remodels,
for example, it will have 3 records in each of the subforms.
My question is - is it possible to link the subforms so that as you advance
through the records in the subform on the Remodel tab, that you also advance
through the records on the other tabs as well so you're always looking at
data for the same remodel from tab to tab? Or, is there a better way to
structure this?