I’m making a base for photography and need to link filters and lenses.
I have one table for lenses and one table for filters. Filter size is the common factor, and I want to show which filters can be used with which lenses.
For example, if the filter size is 52mm, I’d like to show that I have both a UV and polarizing filter in that size. Also, on the entry for 52mm polarizing filter, I’d like it to show me a list of lenses I have that fit.
Can this be done?