show record based on user table info August 20, 2019, 09:09:38 PM HiId like to display a record from Table A that has the field company. company is also a field in the user table.Ive seen the global constants like USER_ID which i can use in a sql query but how do i do the same with alternate field of the usertable as these are not constants as far as i know. Or can i just do USER_company as argument in the query ? Quote Selected
Re: show record based on user table info Reply #1 – August 21, 2019, 08:53:52 AM @nepo77 Why not use the User Records Management to achieve the same result. Quote Selected