Filemaker Security Question
I work for a company that has multiple brands. I am trying to setup a database that will allow some users to enter assets into the database and assign it a brand. Users can then do searches for those assets but some assets will only be available for people who work for the brand that owns the asset. The availability will also change based on the date the asset was entered. After six months of not being used it will be available for al brands
Any thoughts on how to set this security up?