Kaw,
I can see an issue right off the bat... You based your table design on what
goes in the box, a flat file like doing it in Excel, instead of a relational
design with normalized data. That is why creating reports is difficult if
not almost impossible because these tables can't *talk* to each other.
Unless I am misunderstanding something...
It looks like to me all these items (your different tables) are in boxes
together and you want a report that says what's in the box? Yes, you can
create a report for table tblLockBox but there is nothing in the other
tables to help you know which Box those are in.... Again, unless I am
misunderstanding something...
--
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:a229eb7b8fcf2@uwe...
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