Note: I am unable to alter the universe structure. I can only work within the universes I’m provided.
The universes do not provide me a direct way of getting the information I need, but they do provide a roundabout method.
Universe 1/Query 1: Sales Record, Including Record ID
Universe 2/Query 2: Record ID and User ID of person who entered the record
Universe 3/Query 3: User ID and User Name
- Record ID (Queries 1 & 2)
- User ID (Queries 2 & 3)
I need to attach User Name to the Sales Record. It’s no problem to attach the User ID to the sales record, but to go one level deeper, I can’t figure out how to attach the User Name up the chain.
Is this possible? I’m getting #Context or #Unavailable errors (as I’d expect).
johnabianchi (BOB member since 2015-02-06)