S
sturose2000
Hello, I've got a pretty general question but I'll try to relate it to a few
specific situations.
*Is it possible to design the structure (i.e. the fields in my tables, the
layout of forms, the queries, etc.) of my database, then selectively "load"
one or more data sets when I open it?*
For example, if I want to build a fitness-tracker, can Mom, Dad, Brother,
and Sister all have his/her own data file? When one person opens the
application, s/he can look only at her/his history....Or, another example,
if I want a copy of the "empty database shell" to give to members of a club,
so that each member can track in an individual file his/her collection of
trinkets relating to the club....
If someone could please point me in the right direction (even simply the
name of a function/operation to do something like this)....Also, if there is
no easy way to accomplish this per se, can you please recommend some kind of
workaround (for example, should I have "duplicate" tables of identical
structure but holding data for each individual user, or should I keep all
the data together and use a switchboard on open to only use one user's data,
etc.)
Thanks in advance,
Stu
specific situations.
*Is it possible to design the structure (i.e. the fields in my tables, the
layout of forms, the queries, etc.) of my database, then selectively "load"
one or more data sets when I open it?*
For example, if I want to build a fitness-tracker, can Mom, Dad, Brother,
and Sister all have his/her own data file? When one person opens the
application, s/he can look only at her/his history....Or, another example,
if I want a copy of the "empty database shell" to give to members of a club,
so that each member can track in an individual file his/her collection of
trinkets relating to the club....
If someone could please point me in the right direction (even simply the
name of a function/operation to do something like this)....Also, if there is
no easy way to accomplish this per se, can you please recommend some kind of
workaround (for example, should I have "duplicate" tables of identical
structure but holding data for each individual user, or should I keep all
the data together and use a switchboard on open to only use one user's data,
etc.)
Thanks in advance,
Stu