Jump to content

Linking 2 databases (HELP PLEASE!!)


mig1980
 Share

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

Recommended Posts

Hello all. I have a bit of a dilemma. This is regarding FileMaker Pro 6.

I have two databases (one new and one with records) that I want to link together. I want to be able to link all fields to the 2nd database and be able to run a find with any of the fields and have it pull up all of the fields. Example, Enter a job number and have it pull from the 2nd database, the location, customer name, etc. (which are all fields located in both databases). How can I do this?

I would really appreciate it if anyone could help me out on this. Let me know.

Thanks,

Miguel

Link to comment
Share on other sites

Sounds like your need a basic Relationship using your Job Number field as the Key field.

For an overview of how to do this, check out your user manual, or the Online Help by searching for [color:blue]About relationships.

HTH

Lee

Link to comment
Share on other sites

Hi there. Thanks for the info. I have another dilemma that was just explained to me. Appearently my users not only want to search by job number and have it pull up all the information listed, but they also want to be able to lookup Customer last name, and address (also have it pull up all the info). Is this possible?

Thanks.

Link to comment
Share on other sites

Did you read the Help I pointed to?

Did you make an ERD of your files? If you do this, you might see better how to structure things so that you can pull the information that the boss/client is asking you. BTW, a relationship can be a Self Relationship, maybe allowing you do do away with the New File.

It may be helpful to us to see a sample of your files.

Lee

Link to comment
Share on other sites

Here is a copy of my file. Let me explain a bit more about what is going on. This file will be pulling information from three other files. Only certain pieces of info will be pulled to help make a condensed file for a group of users. The file is broken down into four sections with the top three being the information pulled form the three files.

I want to be able to search by key fields, such as date, job number, customer last name, etc and have it pull up all the info for that particular client or job. The password to this file is "rosa" Let me know what you think.

Thanks a lot.

Miguel

Database.zip

Link to comment
Share on other sites

That is exactly what I want to have done. I don't want the data to duplicate in the new file if at all possible, simply find a job number and have it pullup all of the related information to have a more condensed view of the other 3 files for a special purpose group of users. Unless anyone would have a better approach at my situation.

Edited by Guest
Link to comment
Share on other sites

This topic is 5743 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.