Add "picture" field according to other field

[kotvana]

Hello.
Excuse me for my English.
I work in a botanic garden, and we have plant's database.
My superior wants to add a picture to every plant.
The name of the every file is similar to "fullname" field of the plant, but not exact.
What is the best way to do this?
Help will be much appreciated!

 

[John Big Booty]

Firstly Welcome to the forum.

The attached sample should give you some pointers on how you can achieve your goal.

Be sure to copy the database and the file flags to the same location.

 

[kotvana]

Thanks.
Maybe I wasn't clear enough.
I already have a very large database with name of plants - in one field.
I need to assign to every plant the correct file - because every file name contains the full name, but sometimes not exactly the way it shown in the database. So, I guess another query is needed, but I don't know exactly how to do it combines with picture paths.
Thank you in advanced.

 

[Simon_MT]

If your file names can't correlate with the existing information, there has to consistancy otherwise the alternative is to create another field to make it possible to referentially incorporate the images.

Simon

 

[kotvana]

If your file names can't correlate with the existing information, there has to consistancy otherwise the alternative is to create another field to make it possible to referentially incorporate the images.

Simon

The file names exist only in windows directory, outside the database. Is there a way to search for a file in windows directory and then correlate it to similar information, including the path?

 

[John Big Booty]

The sample I posted demonstrates a method by which you can show your images and the plant details. What you are going to have to do is come up with is a method by which you collect and associate the correct image file with it's match plant record.

 

[kotvana]

Well, isn't there something like "like" in queries? I just dunno how to use it to find data and write it in the right place....

 

[John Big Booty]

Yes there is a Like criteria.

I would probably start by looking for exact matches, and get those out of the way before you start widening you search criteria. If you eliminate the exact matches first, it should reduce the amount of work you need to do to verify matches as your search criteria gets broader.