I've looked around here to see if this can be done, but haven't found
the answer. Here is what I want to do...
I have a two databases -- One for Sales and one for Operations. These
are used by two groups of people with some obvious overlap (like the
boss, for example). Some of the data is the same, so I'm using only
one backend database file to hold the data. However, I want to have
one piece (projects) from the Operations database to also be used in
the sales database. The projects piece of it consists of several
forms, subforms, reports, queries, code, etc.
To cut down on maintenance (so without actually importing) I want to
be able to use those forms, subforms, etc. in the Sales database,
exactly as they are in the Operations database.
Is there a way to do this so that any changes made in the Operations
database are also reflected in the Sales database? I've never created
Add-ins before, but before I go trying to make this happen, is this
the way I need to go? Would this even work? I guess what I'm saying
is I want to link code, forms, reports, etc. just like I can link
tables.
Any ideas?