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