Software

Ask something
Question Locked

Access Database

0 helpful
2 replies

by cookieorc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am working on a software inventory database. I have run into a major problem.

I do not know how to set it up that I can enter in 1 software type with more then one license key. I have my main software table then there is a license table with. The license table has the softwareID and the License key. The SoftwareID has a one to many relationship with the Software table...

I am teaching myself access.... So any help would be appreciated.

*edit: I would just have a single box that can add several keys, but I really want it to look professional... Like have an add license button or something like that.

2 replies

by ralf.diller

Hi I guess it should be like this:

Table Software:

Software_ID -> autonumber,key, no duplicates
Software_description -> character

Table License:

Licence_ID -> autonumber,key, no duplicates
License_number --> char,no duplicates
Software_ID --> number, duplicates allowed

Another possibility could be working with a Crossreference table in wich you link the software_ID to the License_ID. Advantage would be a variability on both sites (i.e. some Software-Upgrade package Licences are for more than one Software -- could happen)

This discussion is closed to new replies.