Hi,

I am making a Loans Database for our helpdesk. The loan transaction is set up in a typical fashion in that there is a Transaction table, an Asset table and a join table for Transaction Line Items. All of this works.

Some of our Assets can only be loaned to students in certain classes. For instance a particular camera is allowed for Art Students and Math Students. Being an Art Student or Math student means that you are a member of certain classes.

So I was thinking I needed a couple more tables, Permissions table with a name (Art) and a list of classes (ART101, ART201). Then, PermissionLines linked to the Assets table. That way an asset is able to have multiple permissions (Art and Math) which in turn refer to a list of classes.

The problem I have with this is when I am at the time of transaction I am in the Transaction table with a portal to TransactionLineItems and I need to run a script that sees if the student (whose data is in the Transaction table in the form of XML data detailing all sorts of information, including all of their classes) is qualified to take out Asset X.

I am really stuck here. Have I gone about this the wrong way? What would that script look like?

Thanks,

Matt

I think I am on to something by using a few "Go to related record" script steps to traverse down to the proper table/record.