AnsweredAssumed Answered

Filtered Table Occurances or SQL VIEW

Question asked by lkeyes on Jun 28, 2016
Latest reply on Jun 28, 2016 by Mike_Mitchell

Wondering how to implement a SQL VIEW type of functionality....


The use-case is that I'd like to be able to have specific layouts for different subsets of the records in a single table...  and not have the user need to worry about or even see a "found set".  So far, the best I can come up with is to query for the subset when entering the layout in OnLayoutEnter so that the user is working with just the found set. But this still allows the user to enter a record that doesn't conform to the criteria for the found set.  


Example:  A contact table.    I have a specific layout for contacts for Massachusetts. On entering the layout, I query for state = "MA"   

I add a new contact, and add the state (MA), and that increments the records in the found set. 

I add another contact and add  the  a different state (NH) and that still increments the visible records in the found set. 


The effect is similar to VIEWS in a SQL database....i.e. "cursors" that behave as regular tables... but that are populated from a query on another table.


Thanks for ideas.