AnsweredAssumed Answered

Creating part fixed relation between 2 tables

Question asked by Stigge on Nov 26, 2015
Latest reply on Nov 26, 2015 by Stigge



Small issue that someone might know a good answer to..


I made an own asset management database with several tables in it..

the relevant ones are:

- PCs (stores all our PC´s and who is using them etc.)

- Software licenses (stores all software licenses that are purchased and info on them)


The PC ID is the relation between them.. So for example PC 1234 have several software installed, then the ID is set to the field ID on the software table. that way I can easy see per PC what software each PC are using.

Now we have decided that ALL PC´s should have one of the software automatically assigned. all active PC´s (not the PCs set to "in store" or the ones set for to be scrapped).. we have today about 1000 active PC´s.. and of that software we own about 1200 software licenses. so the records in the software table will cover it for sure.

Is there a way to create that ? Or do anyone have any good ideas on how I can solve that ?