Hey all,
I'm trying to figure out a way to keep a dataset that I need to access, but not all the values may be linked to anyone in my database...yet. The data set I have is keyed/linked off a zip code. There are then five interesting fields about that zip code I'd like to store. However, I'm trying to keep as many zip codes as possible to reduce the work in the future, which means some zip codes won't be tied to anyone. When I've tried to upload to my current custom object, only the zips that match a zip are updated.
From my research, I think an intermediary/bridge/edge relationship will solve this. It seems as though I should create a new edge object that has all of the zips + five interesting fields, and then a bridge object that links to the lead zip code, and then the edge object zip code. However, the part that is confusing me is now I don't know how to access those five interesting fields?
Is the answer simply that I need to create two edge custom objects that are zip + two fields and zip + three fields (given the three link max) and then link/dedude on all of those?
Adchoices