list box set to accept multiple entrys

[danblack30]

I have a list box set to accept multiple. I have three names in it...Justin Jeff Dan. When I click on the dynamic button and select value equal to <%= (Recordset1.Fields.Item("Res_By").Value) %> , I get 1 name returned(highlighted) but not when I select multiple names. I assmue it's because the field on a multiple select would be Justin, Dan (for example) and that wouldn't match the list menu entries.
Any ideas??

Thanks,
Dan

 

[Sheco]

But if more than one ITPerson is part of the resolution that would put you right back to the comma delimmitted string problem.

I like your Active flag on the HelpRequest table... thats a good idea. I put the Active on the ITPerson table just in case, you know, just in case one of the support people quit or took a different job outside the IT dept.

 

[DotNetGnat]

ok got the point...so i guess he can now just have ITPerson and HelpRequest tables as suggested and a correlation table( thats the db jargon) which is maintains...many to many relationship between ITPersons and problem tickets...

RelationsTable
______________
ITPersonID
TicketRequestID

-DNG

 

[Sheco]

Yeah that would probably be cleaner than the way I had it with the resolved date in the many to many table... resolved date belongs with the other help request details.

 

[danblack30]

Ok got some other projects out of the way.....

Now to redo my database structure, your telling me to split out the tables like so?

HelpRequest
-----------
RequestID (unique primary key number)
RequestDate (datetime)
ProblemText (character string)
ResolvedDate
ResolvedBy (ITPersonId who resolved/working on the issue)
Active (true/false flag to indicate whether the problem is resolved or not)
AdditionalNotes

ITPerson
-------------
ITPersonID (unique primary key number)
Name (character string)
Active (true/false flag)

RequestITDetail
-------------
DetailID (unique primary key number)
ITPersonID (many to many relationship with ITPersonID on ITPerson Tbl)
RequestID (many to many relationship with RequestID on HelpRequest Tbl)

I'm a little confused on how to make the logic work though. The admin page where I write notes, give a resolved date, and select the person(s) who resolved the issue would need to be submitted to two tables. Notes and date to HelpRequest and resolved by to RequestITDetail. (Is that correct?)

Lets say Jeff received the ticket did some work wrote some notes and added himself to the resolved by field, but didn't resolve the issue. I come later do some more work add some more notes also add myself to the resolved by field (list/menu dynamically highlighting all admins working on the ticket) and check "resolved" before updating. (update one table insert into another with the same submit button, would that be 2 records or 1 record with a comma deliminated field)

I already have a user table but it has all the users form different departments (each department has it's own version of helpdesk requests), so should I add a new column in that table and add IT, cerf, grounds, maint., cell phones, etc. per user and use that to populate the admins field for each form. (some people would be admins for more than one form.)

Or possibly one table for useraccess and a seperate table per dept. for form admins.

Sorry It's so long winded, just need a little push in the right direction.

Dan

 

[DotNetGnat]

wow...very old thread...i have to read it from the beginning to see whats going on...

-DNG