While an ODBC connection should be possible, I suggest importing your data into two tables in FileMaker to gain better options for working with your data in a relational context.
You can link your two tables in this fashion:
Managers::__pkManagerID = Properties::_fkManagerID
A container field in Managers can store a picture of the manager. _fkManagerID can be set up with a value list of manager ID's and their names as a "beginner level" setup and other more sophisticated ways of finding the right manager to assign to a given property can also be setup.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Thanks, that's what I'm trying to do. The main issue seems to be the error I get when trying to enter a New Data Source. The drop down box contains the name of the file I want to insert but then I receive the message: "The ODBC data source you have selected is not supported."
The main table was a file exported to Excel and then FileMaker converted it so it could be used. The main table was called Property Details Database but after conversion the word Converted was added to the file name so now it works fine. Table two is the one I can't add for some reason.
Use Import Records from the FIle Menu to import your data instead of trying to select the file as an external data source. There is an option in the target table drop down for automatically creating a new table to store the imported data.
Then you can go to Manage | Database to establish relationships, set field options, etc.
Thanks, that got the relationship established but I don't have any photos in either table. Any thoughts as to why my photos aren't in the second table?
Where were the photos to begin with?
If you can see them in your excel file, does your excel file contain physical copies of actual image files or just links to image files also stored on your computer?
The Excel file contains photos in jpg and maybe bmp formats I think. When I was saving them to my Pictures file I had the .jpg selected but I noticed when checking to see how they are stored that one had the .bmp file type. Then I would go into Excel and use the Insert Picture function.
Some photos were then tiny thumbnails that I increased the size on those. Most were large so I increased the cell size so they wouldn't overlap. I don't think that would case an issue though.
That's not the complete answer to my question. But I suspect that images in the excel work book can't be imported. If you have these image files saved in a folder and their file names contain a manager's name or some such data, you might be able to use Import Records | Folder to import them into a third table that you can then link to records in the Managers table.
Or you could add a container field to managers and use Insert Picture to insert the original image files one at a time...
I used the Import Records | File option to import them into the second table. The text fields imported perfectly, no photos came thru at all.
The photos originally were copied from mainly LinkedIn.com and other corporate websites.
I have seen other a couple other posts where it was suggested to link the photos one-by-one (I think) but the whole idea is that since managers change properties so often if the photo links to the name it can easily change when the managers change properties.
The change in managers won't change the pictures if the picture records link to a manager record instead of a property record.
Correct. Managers will change and their photos will follow them to the new property.
The Photo fields are both Container type fields. I just need to get photos to appear and then I can worry about making sure my relationship is correct.
Yes but if you don't have it set up correctly, you will be inserting your photos in the wrong place.
If these are photos of the manager, insert the photos into a container field in the managers table or into a photos table linked to the managers table. If the photos are photos of the property, insert them into the properties table or into a photos table linked to it.