Jump to content

Linking 3 Databases


jnfaison
 Share

This topic is 6535 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

  • Newbies

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-

Link to comment
Share on other sites

This topic is 6535 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.