I created a solution using the Selector Connector Method. I built a primary dashboard off of the Selector table with portals to various tables that can be used to create records on those tables. Now I find users are getting a record lock message whenever another user has a record open in any portal connected to this table. It was my understanding that if every field in a table was a global, then FM would not open the record and a user would never run into this error. Any thoughts or should I just resign myself to a session model?
(I know I let my Relationship Graph grow a little out of control, I just have 80 tables so it is sometimes hard to keep track)