Unique Value check

[Steve S]

I have a small database I use to keep track of software serial numbers for my workstations. What I am trying to do is find a nice way to handle software licenses.

I have 2 tables Users and Workstations. The software serial numbers are on the user table.

Idealy, I want to be able to view a layout for users, see user name with their list of serial numbers and aside the serial number a count of total occurances.

Joe Schmo

photoshop xxxxxxxx-xxx 1

illustrator xxxxxx-xxx 4

quark xxxxxxxx 1

where the ps and quark serial numbers are unique, but the illustrator is used by 4 people total.

I know this might be a bit much. I would be happy with just a check. Is this value unique? if not I can show a checkbox or something to signify that it is a license or should be checked.

I've been playing around and can't find anything other then actually performing a find. and then it would only work for one software license at a time.

Is this possible in fmp?

Thanks,

Steve

[DykstrL]

I would think it would be easier to track serial numbers if you had a 3rd table with the serial numbers. That way you could do the counts by relating to how many users are related to which serial number and to which workstation. As part of that table, you could also have a field to indicate whether the SN is for just one user or for how many.

[Brian C]

Employees may come and go, but this should not affect the software installed on a workstation or the serial numbers associated with the machine. So in reality the software does not belong to the user, so much as it belongs to the workstation that it is installed on.

The following setup will allows you to assign one or more persons to a single workstation.

Searching for a workstation instead of a person shows you who is currently using it and the serial numbers associated with it.

If only one user is assigned to a workstation in your workplace, this should work as you intended, the only difference is that you just go to the Workstations table instead of Users.

Tables

---------------------------------

Users:

UserID

UserName

---------------------------------

Workstations:

WorkstationID

WorkstationDesc

UserID

**********

Relationship

[cliftong]

Yes were using the net bios name as the ID for machine. And I have five tables users, machine,printers, machine contents(software installed), and software. We only use site licsences but as you know there is more than one software installed on a machine. I scared when i see in my relationships graph 10 items on the machine contents table going to on field on the software table. Thank for the reply in the first place and so quickly too!