I don't understand... this should be simple

[JKeats]

I've set up a series of databases in order to track the paper-filing system here in the office. The idea is that now that I have entered the names of all of the files in the filing cabinets, when we want something, but don't know exactly which file we are looking for, we can search through the database to find the name and location of the file we want.

These are reas simple databases. Theres a seperate database for each file cabinet drawer and the only fields are filename and creationdate.

In my master database, I have set up a relationship to one of these other databases (i'm starting small with just one until i can get things to actually work). I've also gone into this other file and set up the relationship there (to the master) as well.

I'm missing a step here someplace because while in the master, I switch to find mode and punch in the name of a file from the related database, and I get nothing. No records found.

How can I get my master database to search through and display the the records in these other databases?

[jasonwood]

Sounds like you might be making this unnecessarily complicated. Why not just have one database total? You only need to add in a field for "cabinet" to distinguish between them.