I have a point feature class with several photo attachments. There are situations where I may want to filter which photos a user can/should be able to view. For instance, A user may only want to view "Finish Phase" photos and not "Construction Phase" photos. I have thought about adding a field to the attachment table and populating with the phase type. However, I don't know if there's a way to apply this filter, or definition query, to the end user. All my data and photos are stored in SQLServer.
Any ideas how I might be able to accomplish this?