Okay here are all four tables Every thing is test box except amount that is
currency
tbllockbox (Name of Table)
lockbox number (Primary Key)
Packet number
Deposit date
Form
Check
No Check
Correspondence
Amount
Rebatch Number
Box Number
Employee Check out
(need to print inventory by box number)

tblscanfile (Name of Table)
Batch number (Primary key)
In Date
Deposit Date
Form Type
Number of Items
Batch Source
Batched by
Amount
Rebatched
Notes
Employee check out
(need to print monthly for book)

tblmanualfile (Name of Table)
File number (Primary Key)
Amount
Deposit Date
Form
Employee
Rebatch number
Employee check out

tblcasefile (Name of Table)
Folder Number (Primary key)
Yr Received (use month and year only)
FEIN number
Company name
Auditor name
Box (box with auditor name and number ( 1-10 ))
Employee checkout
(need inventory of what is in box by auditor)


Gina Whipp wrote:
Kaw,

No screen shots won't help... Here's what I am asking for

tblNameOfTable
NameOfField
NameOfField

tblNameOfTable
NameOfField
NameOfField

Do that for all four tables. Indicate if any of the fields are Primary
Keys.

would it help if I emailed screen prints? I am a newbie to Access so not
sure
[quoted text clipped - 14 lines]
to
print out what is in each box.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201001/1