tblPCPrinters
PC_ID PR_ID DefaultPrinter
1 1 1
1 2 0
1 3 0
2 3 0
2 1 1
SELECT PC.PC_Name
, PR.PR_Name
, PCP.DefaultPrinter
FROM dbo.PCPrinters PCP
INNER JOIN dbo.PC_List PC
ON PCP.PC_ID = PC.PC_ID
INNER JOIN dbo.Printer_List PR
ON PCP.PR_ID = PR.PR_ID
tblPCPrinters
PC_ID
PR_ID
DefaultPrinter
The table would have a Primary Key of PC_ID and PR_ID and DefaultPrinter would be a BIT field (Yes/No)
Cheers, Andrew