Skip to main content
Question

Can users change field value in report with a dropdown menu?

  • January 29, 2020
  • 0 replies
  • 25 views

I have an app that displays employees, their status, along with other things. I have an employees table and a status table. I would like to give users the ability to change the status with a dropdown menu listing all the statuses. 

The status table is the parent and the employees table is the child (many employees can use the same status).

------------------------------
Thomas LaMotte
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • Registered
  • January 30, 2020
Thomas,

This is your table structure.



Make sure Status in the Employees table is a look up value and the proxy for Related Status
Ensure that the Users can modify the field Related Status
Build a Record Picker report in the Status table that includes the Status values you want the Users to have access to.

Let them lose on their own record.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------