Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Running a report from 2nd data base


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

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

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.

Link to post
Share on other sites

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

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.

×
×
  • Create New...

Important Information

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