On 2012 Oct 14, at 21:58, Jay Erlebacher wrote: > OK, I am not following... > I can export images of the reports by "printing" the images in pdf format > into iPhoto. > Each iPhoto image has a unique ID such as "6k7HMh", but I have no idea where > this ID comes from. > How do I get the appropriate Patient ID, date and report type to be > associated with each image?
DO NOT USE A CONCATENATED KEY! Instead, assign each record a unique sequence number and maintain the associated information in separate fields. It sounds as if the iPhoto images also have unique keys of their own. Each such key should be treated as the contents of a field within your database. Thus your new database record would contain these SEPARATE FIELDS: • record sequence number • iPhoto image number • Patient ID • date • report type • the image • other associated data
