I have a report right now that works great. This report displays "Locks" for a specific procedure.  I was asked when they hired me to add functionality to have "locks" that are not required, but still display them on the form.

 

I thought that a simple way to do this would be to put a flag on the lock table to see if it was required. This is not the case.

 

The way they wanted it was to have a seperate table for "Prepared" procedures.... and that way you can have say "prepared procedure 1" and "prepared procedure 2" that link to the same set of locks, but each can have there own seperate locks that are required.

 

I acomplished this by adding a "prepared" table, and a "unusedItems" table which is linked to the prepared table and the locks table.

 

As it stands now, I can read the procedure and all the assigned locks to it, but i want to be able to tell if the locks are in the unused table, and if they are....have the background silver (or have that record....greyed out, still visible, but so they know that they dont need it)

 

I know this sounds alittle confusing. But if you need more clarification, let me know. I am stuck and need this done by Tomorrow morning.