Skip to main content

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?

Ack… I figured it out! This software is so cool!!!


Hi @KFerris !


Go visit this page, you’ll find a very good tutorial to get familiar with linked records (it’s not that hard, don’t worry :winking_face: ).


Edit: looks like you already got it, good job! :thumbs_up:


Hi @KFerris !


Go visit this page, you’ll find a very good tutorial to get familiar with linked records (it’s not that hard, don’t worry :winking_face: ).


Edit: looks like you already got it, good job! :thumbs_up:


Yup… added a lookup command to one of the tables. This is really cool! I’m planning on using it for work, but playing around learning it with personal projects. I have one base for photography, one for sewing projects, one for travel plans. Super fun! Where has this been all my life?!


Yup… added a lookup command to one of the tables. This is really cool! I’m planning on using it for work, but playing around learning it with personal projects. I have one base for photography, one for sewing projects, one for travel plans. Super fun! Where has this been all my life?!


It’s a great tool to work with for sure!

Glad you figured this out on your own, it’s always the best way to learn 🙂


Reply