Forum Discussion
Creating a lookup table, but one problem...
One way to handle this many-to-many problem is to create a "bridge" table that contains a unique list of divisions. Your tables can then be connected by many-to-one relationships. If you set the relationship to be bi-directional, then filters should flow from the ranges table through the division table and into the sales table, effectively creating a many-to-many relationship.
The model would look something like this:
One way to handle this many-to-many problem is to create a "bridge" table that contains a unique list of divisions. Your tables can then be connected by many-to-one relationships. If you set the relationship to be bi-directional, then filters should flow from the ranges table through the division table and into the sales table, effectively creating a many-to-many relationship.
The model would look something like this:
Thank you!!!!! That worked!
