I have 2 lists I am using for an item checkout list. The first list is theinventory items, and the second is the check out request list. When a personchecks out an item I need to ensure that the item is not already checked out forthe specified time. How can I do that in an SPD workflow? I've already got thecheck out, and checkout expires automatically at the end of the specified time.Just need to get the piece that ensures the item is available for that time!
Sorry, that should say "I have 2 lists I am using for an item checkout tool." Irealize this description might be clear as mud so feel free to ask questions forclarification!Oh yeah, I am using MOSS 2007.
How are you identifying the item in the checkout list -- with a linkedfield, or something else?I know you can do things like "compare value", "create new list item", and"update list item" based on criteria; where are you getting stuck?
In the checkout list, for any items that are checked out I have stored the ID ofthe requested item. When someone checks out another item I don't care which oneit is as long as it does not conflict with any other reservations. Reservationsare stored with "From" and "To" fields. There are only 14 items in the list toreserve, so not too cumbersome.