Jump to content
Sign in to follow this  
Dono K

Need to cross-reference records... a self-join?

Recommended Posts

Sorry - I don't know quite where to start here, but I have a photo database and I need to cross-reference some photos that are related within the same table. (If the photo is a composite, I want to reference the foreground and background images that created it.)

i.e. In the table I have a text field called "version_name" and a photo container field called "photo". I want a drop-down menu of all images in "version_name" to select as a foreground image and then a thumbnail of that foreground image from "photo".

I assume I do this through a portal, but I can't seem to get the cross-reference correct. I really don't know where to start. If they were in separate tables, I could make it work, but this stumps me... Help?

Thanks in advance -- Don

Share this post


Link to post
Share on other sites

Forgive my inexperience with photography, but shouldn't you have a parent record?

For example, I probably would want a parent record that has details about the "collection". Then I would want to choose different pictures and assign them as foreground, background, etc.

I mean you can possibly pull it off with a self join but I think you may want a second table or perhaps may even need a third depending on your exact needs.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.