MS Access 07 - Relationships problem
I have a dilema where I am trying to create a consumables database, where we book in and out toners.
Where I am having trouble is with the relationships between 2 tables (printers and consumables) which a many to many relationship, which is not possible. The first relationship is from the Printers table to the Consumables table, where a printer can have many consumables (Colour printer).
The second relationship is between the Consumbles table to the Printers table, where the consumable can be used by more than one printer (one cartridge works with many printers).
Has anyone got a database similar to this or can shed some light on this.