Re: Pictures in Forms associated with specific ID's

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In each of the three table create an OLE field for the graphic. The stored
ID as you have described is the way to go. When you want to display the
scouts info in a form or report use a query of all four tables (main, patrol,
rank, position) with relationships from the main patrolID to the patrolID in
the patrol table, etc.

Jason Lopez wrote:
The way I have it set up is to have one main table with the basic scout
information. A second table will have the patrols; third, the ranks;
fourth, positions. When the form is created, I am hoping to have the ID for
the respective patrol, rank, and position, recorded in the main table as a
number (ID number for respective patrol, rank and position). Users will
select using the name, but ID number will be recorded instead.

Then, once that selection is made, I am wanting to have an automatic update
through the "After Update" event to display the appropriate graphic for
rank, position and patrol. But, how do I set up tables or associations so
that the images are displayed correctly?

As I mentioned before I found something once that showed how to set up
something like this. But I cannot seem to find it again.

Jason Lopez

About what graphic are you speaking? If you want a graphic of say their
rank
[quoted text clipped - 26 lines]

Jason Lopez

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Pictures in Forms associated with specific IDs
    ... The way I have it set up is to have one main table with the basic scout ... number (ID number for respective patrol, rank and position). ... that to display so that as I cycle through each boy, ...
    (microsoft.public.access.forms)
  • Re: CSI Miami Bald Cop?
    ... shaving his head, and moving to patrol? ... I was surprised when someone said it was a promotion. ... that going from detective to patrol would be ... He went up in rank and pay grade. ...
    (rec.arts.tv)