Kaw,

We will be here should you need more help!

You're welcome!
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kaw via AccessMonster.com" u57493@uwe wrote in message
news:a265b4c5476c2@uwe...
Thank you for your help. I am creating the table as you have said and
trying
it out.

Gina Whipp wrote:
Kaw,

Preliminary table layout...

tblLockBox

lbLockBoxID (PK - Text)

lbPacketID

lbDepositDate (Month and Year can be gleamed from here)

lbForm

lbFEINID

lbCheck (Yes/No field (Yes - Check - No = No Check)

lbCorrespondence

lbAmount

lbBatchedByID

ldBatchSource

lbRebatchNumber

lbEmployeeCheckout

lbNotes

lbAmount

tblLockBoxDetails

lbdFileID

lbdFEINID

lbdCompanyID (FK)

lbdInDate

lbdDepositDate

lbdFileTypeID (FK - Scan, Manual, Case, etc. See table below)

lbdAuditorID (FK)

lbdQuantity

tblFileTypes

ftFileTypeID (PK - Autonumber)

ftFileType

tblCompanies

cCompanyID (PK - Autonumber)

cCompanyName

etc.

tblAuditors

aAuditorID (PK - Autonumber)

aFirstName

aLastName

etc.

Let me try to explain more in depth. For example my first lockbox has
100
bundles. Each bundle of papers can have up to 30 taxpayer paperwork. So
I
[quoted text clipped - 29 lines]
to
print out what is in each box.

--
Message posted via http://www.accessmonster.com