Assignment Indication

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All

I am developing a database in Access 2000 to keep track of all of my computer hardware and software. All of the software will be in one table and all of the hardware will be in another. The information in the two tables will be bought together to create computer workstation information.

i.e. Station 1 could consist of:

Hardware
Apple Mac G5
Laice 19†Flat Monitor
Apple Keyboard
Apple Optical Mouse

Software
Mac OS X
Quark 6.0

What I want to do is indicate what hardware and software is used when it is assigned to a station. Also the opposite when it is unassigned. Also a warning will have to appear if you try to assign software or hardware to two workstations.

Does anyone have any ideas?

Thanks

Sean
 
You don't really need a separate field for "assigned" or "unassigned". If
there is a reference to the record in the workstation table, you know it's
assigned. So you can use a query to calculate the value. The query is a
little tricky (but then, so is maintaining an "assigned" field) -- you need
to do an outer join between the hardware table and the workstation table
(check the box that says "include all records from workstation...") and
select for the hardware id being null.

That probably seems a bit vague...tell me what your tables look like and
I'll give you something more specific.



--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Sean said:
Hello All

I am developing a database in Access 2000 to keep track of all of my
Click to expand...
computer hardware and software. All of the software will be in one table and
all of the hardware will be in another. The information in the two tables
will be bought together to create computer workstation information.
i.e. Station 1 could consist of:

Hardware
Apple Mac G5
Laice 19" Flat Monitor
Apple Keyboard
Apple Optical Mouse

Software
Mac OS X
Quark 6.0

What I want to do is indicate what hardware and software is used when it
Click to expand...
is assigned to a station. Also the opposite when it is unassigned. Also a
warning will have to appear if you try to assign software or hardware to two
workstations.
 
Back
Top