I have two tables. My main records table has two fields that reference a users table. The users table has a "user type" column and the two main record fields reference a different user type. For example, Manager & Supervisor. The main record form allows for new Managers and Supervisors to be added, however the user of the application will be required to pick if they are Manager or Supervisor. Is it possible to pre-populate the "user type" depending on which field they are adding a user to? I unsuccessfully tried the CONTEXT() function as it doesn't appear to control this "pop up" view when adding new items to a referenced table. Any ideas?
LinkedIn
Twitter
