So I have records that have fields that contain multiple values:
For example:
|ID |------ |Agency| ------ |EntitiesImpacted| ------ |Content|
_______________________________________________
1 | ---| SEC, FED, FDIC | ---| SBNA, BSPR | -------- | Rules
2 | -- | FED | ---------------| SSLLC | ---------------| Bulletin
3 | -- | SEC, OCC | ---------| BSPR, Totta | ---------| Rules
Sorry for the terrible image. Hopefully you get the idea, though.
I originally created this table using a Relationship & Lookup field, but that caused a ton of querying problems. I'm not sure how to effectively set up a database that has fields with multiple values per record in the field!
Any advice is greatly appreciated.