Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-16-2018, 08:39 AM   #1
brendonp
Newly Registered User
 
Join Date: Mar 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
brendonp is on a distinguished road
Incorporating fields from a number of tables in reports.

Hi. I don’t think I’m using the right terminology here but ......
I am trying to design a report that shows a list of bulletins from a table ‘tblBulletin’. One of the fields in this table ‘ClientID’ refers to another table ‘tblClient’. Rather than displaying the autonumber field ClientID in the report, I want to display the clients first and last name from the table ‘tblClient’.
Additionally i want the first and last name to appear like a name rather than 2 separate fields.

Attached is the relationship table of the database. I want to do this a number of times throughout the forms and reports.

Many thanks




Sent from my iPhone using Tapatalk

brendonp is offline   Reply With Quote
Old 04-16-2018, 08:57 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,850
Thanks: 9
Thanked 3,827 Times in 3,770 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Incorporating fields from a number of tables in reports.

You base the report on a query that joins the necessary tables, enabling you to return the descriptive field instead of the numeric key field.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 04-16-2018, 09:14 AM   #3
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,809
Thanks: 10
Thanked 2,115 Times in 2,070 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Incorporating fields from a number of tables in reports.

Quote:
Attached is the relationship table of the database
You need to fix that before you move on to reports. There should only be one way to traverse from unique tables in a database. You have created a spiderweb that will surely haunt you when you start writing queries.

Again, only 1 path between tables. From tblStaffProfessional to to tblClient I can draw 3 ways to get there. This is incorrect. I don't know enough about your data to tell you which is the only path you should have, but I know you have 2 too many.

Additionally, tables with only 1 real field of data (autonumbers don't count as real data) shouldn't exist. That means tblSecurityLevel, tblGender and tblTitle are unnecessary. Instead of storing the autonumber value in the foreign table, just store the value it relates to there.


+1 for literally taking a shot of your screen with your phone.

plog is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
summing calculated fields on reports and tables to include cents alejo8955 Reports 2 02-20-2014 07:54 AM
Reports: Summarising multiple column data from tables into rows in reports nnabbale Reports 5 02-23-2012 03:08 PM
Table Fields (Name / number) dependent on another Tables data. Kelemit General 15 06-01-2006 05:37 AM
[SOLVED] number fields in text to number field, formula for fiscal year shurleexyz Tables 6 01-03-2005 09:15 AM
Tables - limit on number of fields? mergle General 4 12-26-2003 08:21 PM




All times are GMT -8. The time now is 11:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World