Jump to content
Sign in to follow this  
Joseph31

Running a report from 2nd data base

Recommended Posts

Hi everyone...

I have 2 data bases:

Main data base -- contains all reports and other information

2nd data base -- contains broker data, which the main report uses to look up broker companies..

I need to be able to print a report (Using the Main Page Report) but using the information on the 2nd data base.

Example:

Main Date Base:

I have a letter that contains company name, company address....Dear Mr. Contact last Name...

2nd Data Base: Broker Data Base

Contains: Company Name, Company address, Contact Name etc....

Help

Share this post


Link to post
Share on other sites

And it takes time to learn, but it can be done. This is a common problem. I for one try to keep all the data in one file and the user interface in another. Makes updating much easier.

To accomplish this, all you need is some way to grab the data out of out of the other database. Usually a global field that relates to a unique identifier in the other, such as a serial number or ID, will do. Then create a relationship to that ID number and you can place any information you wish on a layout relating to that record in the other database.

Share this post


Link to post
Share on other sites

is there an example you could show me that I could learn from.... If not Iwill ke trying what you said... Thank you smile.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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