Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Display linked images...?


Recommended Posts

More help on a probably very simple query please.

It's that acupuncture database again, which is growing up nicely, but a bit of a troublesome adolescent right now.

I have a 'Treatments' table, for acupuncture treatments given to clients. The acupuncture points used are recorded using a drop-down list that pulls in data from another table, called 'Points'. At the moment it is an un-related table, and just used as a simple value list.

However, each point (there are over 300, or will be when I've put them all in) has a diagram attached. I would like to be able to display a small version of the diagram - as a 'container' - alongside the points.

At the moment I'm not able to do this, mainly, I suspect, because the 'Treatments' and 'Points' tables are not liked.

Finally, the question. How do I set things up so when I enter a value from a value list (which is also a table) can the table you're entering the value in to also 'pull over' the relevant graphic image, which is another field in the 'value list' table.

Again, thanks. I will quite happily offer a few free acupuncture sessions to anyone who can sort me out, and lives within easy travel of West Yorkshire!

Link to comment
Share on other sites

a) The diagrams should be in Container fields in your Points table, one container field per Points record.


b) Whatever field the dropdown value list of points is attached to should be hooked to the field in Points that the value list gets its values from to begin with. That becomes your relationship between Treatments and Points.


c) Once you have such a relationship you can display the related field Points::ContainerField on your Treatments layout.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use