Many-to-Many Relationship Table

Something like this what you are after?

CREATE TABLE Computer
    (
      Asset INT NOT NULL
                PRIMARY KEY ,
      DefaultPrinterID INT ,
      WristbandPrinter INT
    )


CREATE TABLE Printer
    (
      PrinterID INT IDENTITY(1, 1)
                    NOT NULL
                    PRIMARY KEY ,
      PrinterPath VARCHAR(15)
    )                 


CREATE VIEW ComputerPrinterReference
AS
    SELECT  c.Asset AS Asset ,
            p.PrinterPath AS DefaultPrinter ,
            p2.PrinterPath AS WristbandPrinter
    FROM    Computer c
            INNER JOIN Printer p ON c.DefaultPrinterID = p.PrinterID
            INNER JOIN Printer p2 ON c.WristbandPrinter = p2.PrinterID
GO

No, something like this:

Then you only put computer information into the computer table. You only put printer information into the printer table. The relationship table defines if it's a default wristband, hoozymawatchit or anything else. Then, the ComputerPrinter table brings them all together. This way you can get listings any way you want them.

I will tell you, the one wrinkle is, if you want to output printers across the page for each computer, you'll need to use a type of query called a pivot. I leave that to you for additional homework.