rhwingo
Member
When creating a query some data items have the ability to have SPECIAL VALUES associated with them. For example: UserID you can say equal to LOGIN ID. I was wondering if you can add to the SPECIAL VALUE for example to pull the AB# from F0092 and have it populate in the query. This way we don't have to hard code Account Managers AB# when creating these Queries and Watchlist. Anybody have any ideas........ Current App is using a UNION over F4211/F42119 and the SDURAB has our Account Managers AB# stored there. Would like to have a query showing all SDNXTR=579 for SDURAB= to the AB# associated to the F0092 USerID.