Hoping to unified same tables for 3 different MS Access file

[blu_macey]

Hello Everyone!

Scenario

I have 3 sets of MS Access File (NEDA, RDC,& Summid) built with the same sets of structures. Originally at MS Access 2007, but now I'm using the built in 2010 version for Lenovo Flex 2.
The table consist of:
*Chart of Accounts
*Journal Entry Voucher Master File
*Journal Entry Number Master File
*Supplier Master File
Queries are the same (links, designed, etc...)
Forms are also the same (links, designed, etc...)
Reports are also the same (links, designed, etc...)

Problem

The difference for these three file is the Journal Entry Number because each file requires a different JEV format
Example:
For NEDA it should be NEDA-Year-Month-Number Series
For RDC it should be RDC-Year-Month-Number Seried
Laslty for summid it should be Summid-Year-month-Number Series
and separate transaction listing for the purpose of calling data for the report, such as List of disbursements and trial balance.

But for these three MS Access file, Chart of Accounts and Supplier Master File do have the same set of data. That's why whenever a data is not available I am encoding the said information in each MS Access file (inputting the data three times).
Example:
If an asset account such as Office Supplies is not available, I will input in the Chart of Account Form for NEDA, then RDC, then Summid.

Question

Is there a way where I can unified the Chart of Accounts and Supplier Master File into one but still can entry/edit the same in each MS Access forms. Also can still link to each queries, tables,and reports?
So that I will encode data one time only and save space.


Any comment, suggestion, violent reaction and Ideas are very much welcome.

Hoping to hear from you soon.

Thank you,
Chino

 

[CJ_London]

combine them in only one db and link to them

 

[pbaldy]

Fyi, approved both posts. CJ, watch for the little icon denoting a moderated post.

 

[blu_macey]

Many thanks sir cj noted but I can't
Many thanks Sir Paul.