At the moment I have 3 tables - Users, Functions and Activities. Each user is assigned a function and there is a table-to-table relationship of "Each Function has many Users". In the Activities table there is a "user" and "function" field. Once you select a user from the list the related function is automatically populated due to the table relationship. Instead of selecting a user I need the user field to auto-populate based on the currently logged in user which I have already implemented. The issue I'm having is that I need a way for the function field to also auto-populate based on the currently logged in user.
I have also implemented a table-to-table relationship between the Users and Activities tables of "Many Activities belong to one user" but am unsure as to how I can get the "function" field in the Activities table to auto-populate based on the currently logged in user, or even if what I'm trying to do is possible in Quickbase?
Any assistance would be much appreciated.