I need to view related fields from Microsoft access in our filemaker database. The access data will go into our report that will be exported or printed out. I have a unique identifier to relate the two databases but I have never related a non-filemaker file before. Just a side note that I did not design the access database and am quite unfamiliar with access in general. Thanks very much in advance.

The two programs are not compatible.

You would have to export and import the data from one to the other.

HTH

Lee

That's unfortunate. Thanks for taking the time to respond.

Let me throw my problem out there then and maybe someone else has a different idea to relate the files.

We have a robot that updates items on an access database with a unique barcode as well as their exact location. This was designed and set up by the engineering company that made the robot. Our FileMaker database keeps our data which we use for these items. When someone requests a set of items they tend to send excel sheets which I can then import into FileMaker to relate the values and produce the barcodes for us to find the items. What I need is to be able to get the location information from the access database.

We would then use this information to print out sheets we would then take with us to get all the items.

I hope this is clear. Any feedback would be greatly appreciated. The access database is constantly being updated as well so I can't transfer it to our FileMaker database or anything.