I've created 3 separate databases for our archived materials (boxes, tubes, and cd's) and each has a common denominator which we call our job number. Each database also includes a box number or tube number or cd number field, so we know where in the basement these are located. In the job number field, there can be multiple numbers. When I link the databases, the search will only give me the first number in the field (they're separated by commas if that makes a difference) All the numbers in the field are relevant and need to be incorporated. I'm trying to link these databases so that when we need to pull an old job, we can find all relavant material without having to search 3 separate databases. Suggestions? Help!

Thank you!

Hi there,

It it's important that your values be seperated by a comma, create a calculated text field in each of your files that looks like this:

Substitute(jobnumberfield, ",","

Well,

Why do you use 3 databases ?

Wouldn't it be better to have only 1 file, with a value list to select the kind of materials ?

My 2 cents

I have no idea (in case that wasn't already obvious) I'm new to this program and set up what was requested of me. I'm just trying to make it simpler for the needs of the office.

John- I tried doing what you suggested, but I think I'm missing something there as well.

thanks-