I am working on an asset inventory database for computers, monitors, printers, etc. PCs and printers each have their own table, but I would like to have a relationship between the PC and printer tables for PCs with a local printer.
This leads me to question if I should have a field in the PC table for the local printer ID, a field in the printer table for attached PC ID, or both. Unfortunately, since not many PCs have a local printer, there would be a lot of nulls in the field in either table. However, it would be nice to easily list local printers (without searching the printer table) on a query of PCs. It would also be nice to easily identify an attached PC (without searching the PC table) on a query of printers.
What are the thoughts on this? Would it be better to create two relationships, or only one? If one, which one? Thanks.