Associate Users > Brands > Files etc

I’m building an app for brands to manage their media, marketing, and tasks in one place and to support the workflow/workload we are stringing other tools together to use.

I’ve got all of the functions ironed out and built… but I can’t get my Database configured properly.

USERS Only have access to “their brands” (Thing 1) and all of those Brands have Offers (Thing 2) which have Campaigns (Thing 3) and Lastly Assets (Thing 4). All Tied together.

I don’t know how to automatically create this association so that when any user uploads a particular file, they select what brand it’s for or the system automatically knows. I have manually updated the Unique IDs to test my other functions and it works fine.

All of my functions are clear. Are there basic tutorials on synching these relationships by Unique ID?