Problem with layout

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I am creating a database for computer/software inventoy I currenly have 3
tables.
Equipment
Software
Assignment

Equipment has the following
Tag#
Location
Description
Model
Manuf
Serial#
PurDate
WarExpDate
Cost
Disposal
DisposalDate

Assignments
ID
Title
Location
JobTitle
FName
LName

Software has
Title
Version
Manuf
Media
License
Quantity
#CD's
Status

What I would like to do is to be able to pull a report 3 ways...
1 list all the software with the # of Licence and the computer tag # it is
assigned to with the location of the related tag# (This way I can tell how
many license I have left.
EX:
Adobe Flash - 9 License
00001 - UP
00056 - CH
00006 - PH

List of all Equipment with the location and person assicated with it.
(this one I have working)

List of Equipment - Location - User and all software installed
EX:
Tag loc man model sn war exp user
000001 - UP - Dell - D830 - 12345 - 11/29/2010 - mrl19
Adobe FM
Office 2007
Flash MP
Photo Editor

Can this be done if so what changes do I need to make to my tables and
relationships.
 
You've provided no information as to how you've related your tables, so it's
not possible to answer your questions.
 
That is one of the issues I am haveing that is why I posted this here. Would
I just add Tag# to Assignments & Software then relate both of them back to
the computer that way?
 
If ASSIGNMENTS and SOFTWARE relate to specific pieces of equipment, then yes,
you'd include TagNum in your other tables, and carry the value forward from
teh Equipment table into the other tables.

One more thing: I never use special characters (like the number sign) in
database field names. It's just me, but I consider it a poor design practice.
Nor do I use spaces. I *will* use underscores, but normally I just capitalize
the first letter of each syllable of the field name. I nothice that you've
done that with some of your field names too. Good for you.

Dennis
 
Thanks for the info on the special char. now a question about your answer
yes the tag is assocated with software and a user, but here is the thing.
Software can be related to more than 1 tagnum same with a user they could
have a desktop or laptop.
 
That's a very simple one-to-many relationship. As long as TagNum is not the
primary key in the software table, it won't be a problem. Note that TagNum is
a Foreign Key to the Software and Assignment tables. It would be the Primary
Key for the Equipment table. And once you have these relationships defined,
manipulating the information via form/subforms or queries becomes an easy
task.
 
Back
Top