Template
BRUTE FORCE Many-To-Many Refs
BRUTE FORCE Method for implementing Many-to-Many References
The purpose of this apps is to demonstrate how you can SELECT() to brute force a many-to-many solution in your app.
- If you just need to get something in place (quick and dirty), this method will work fine for you
WARNING: This is inherently inefficient, and should be used with caution
- If you expect your system to continue in complexity, or if you're planning on having more than 5,000 records, they you may want to go the Join table route.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This app consists of two primary table - which we want to many-to-many connect together.
- This is accomplished through manually creating a virtual column with a collection of SELECT() formulas
- The idea is to search through the DB and find:
- All the records on the opposing table that this record should belong to
- All the records this records SHOULD NOT belong to
- And combining these together, along with whatever has been designated by the user in the manual entry field, giving us a grand final list of everything that should be connected
- This setup must be implemented on both ends
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I BET YOU THOUGHT IT WAS GOING TO BE AS SIMPLE AS DROPPING A SELECT() IN A VC AND CALLING IT GOOD! (^_^)
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...