Keeping Collection Items to a Minimum

Hi Everyone!

My site tracks grocery items from multiple stores. The challenge I currently have is that a single item, say “Kraft Mac & Cheese”, can be on aisle 10-B at ChainstoreA, located in one town and on aisle 9-A at the same ChainstoreA, located in another town.

I could create a new item in my Collection for each store, but my Collection size would dramatically increase with duplicate items just for the sake of the different “Aisle” entries.

Any suggestions on a method to handle this?

Should I some how use an array?

Hi,
You can use Reference fields to link one collection with other collections.

Best,
Tal.

Hi Tal,

Thanks for pointing me in the right direction! I’ll have to look into Reference Fields and start experimenting!

If you celebrate Christmas, have a very merry one!

–Chris