I trying to design a Notes 7 database that will store activity for a given set of accounts. The accounts have
separate managers and I need the view to filter the account activity so that managers only see the detail for
those accounts that they are assigned to. I considered doing this via a private query, but I haven't used embedded views before and it looks like I could get the same result via that. I've been toying with it but I'm struggling a bit. The base view lists all accounts with the first column being categorized by account name and the next 3 being account activity. I took this and added to a form as an embedded view, then added code to the show single categories (Account = "name of the account"). When I try to create the form it
failed telling me that the Category must be a single string.
Could give me some insight as to what that's telling me? Also, I'm concerned that I'm off on this approach too. Is there a better way to filter, or leverage security, on a view? For a row, not a column?
Sorry to be so long-winded.