I think that maybe correct. I am trying to use Access as an inventory system
but my files only move once a year. Do you have any suggestions that may work?
I am trying to quit using RedBeam
Check In/ Check Out because it gets quite full and quits working then I have
to pay them to update the database. The last time it took 9 months before
they got it right. I cannot operate like that it gets me behind.

Gina Whipp wrote:
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...

Okay here are all four tables Every thing is test box except amount that
is
[quoted text clipped - 66 lines]
to
print out what is in each box.

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