Display name on report instead of corresponding autonumber identif

  • Thread starter Thread starter richardgsmith
  • Start date Start date
R

richardgsmith

Using Access 2003 I have a created a simple database to coordinate the
delivery of presentations to teams within the organisation. I have three
tables [tblteams], [tblpresenters] and [tblpresentations] (field details
shown below), from which I have created a form (using a query to draw
together the relevant information from the three tables).

From a relationships point of view, there is a one-to-many relationship
between the [PresenterID].[tblPresenters] and the
[PresenterID].[tblPresentations] fields (the same is true of
[TeamID].[tblTeams] and [TeamID].[tblPresentations]).

I have used autonumbers, [TeamID] and [PresenterID], as the primary keys in
the [tblteams] and [tblpresenters] tables respctively and have then used the
bound column/coulmn count combo-box options to display the team name and
presenter name on the form (rather than the corresponding ID number).

I now wish to create a report using essentially the same data I have used
for the form, but do not know how to display the team and presenter name
instead of the ID number. Can anyone help?

==================
Table outline composition:

[tblTeams]
[TeamID], [TeamName], [ContactName] ... etc.

[tblPresenters]
[PresenterID], [PresenterName], [PresenterPhone] ... etc.

[tblPresentations]
[PresentationID], [TeamID], [PresenterID], [Date], [Time] ... etc.
 
Create a query using all 3 tables.

Use that query as the source for the report, and you can output the names
form the lookup tables.
 
Thanks Allen, for some reason I had not tried just inserting the
[TeamName].[tblTeams] field into the query already!

Any ideas why I am prompted with "'Enter Perameter Value' TeamID" when i
switch from design view to print preview? (If I just bypass by clicking ok
this seems to work, but I wondered why I was getting the box in the first
place!)


Kind regards,

Richard.

Allen Browne said:
Create a query using all 3 tables.

Use that query as the source for the report, and you can output the names
form the lookup tables.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
richardgsmith said:
Using Access 2003 I have a created a simple database to coordinate the
delivery of presentations to teams within the organisation. I have three
tables [tblteams], [tblpresenters] and [tblpresentations] (field details
shown below), from which I have created a form (using a query to draw
together the relevant information from the three tables).

From a relationships point of view, there is a one-to-many relationship
between the [PresenterID].[tblPresenters] and the
[PresenterID].[tblPresentations] fields (the same is true of
[TeamID].[tblTeams] and [TeamID].[tblPresentations]).

I have used autonumbers, [TeamID] and [PresenterID], as the primary keys
in
the [tblteams] and [tblpresenters] tables respctively and have then used
the
bound column/coulmn count combo-box options to display the team name and
presenter name on the form (rather than the corresponding ID number).

I now wish to create a report using essentially the same data I have used
for the form, but do not know how to display the team and presenter name
instead of the ID number. Can anyone help?

==================
Table outline composition:

[tblTeams]
[TeamID], [TeamName], [ContactName] ... etc.

[tblPresenters]
[PresenterID], [PresenterName], [PresenterPhone] ... etc.

[tblPresentations]
[PresentationID], [TeamID], [PresenterID], [Date], [Time] ... etc.
Click to expand...
Click to expand...
 
Is your query outputting the TeamID from 2 tables?

If so, the name TeamID is ambigous, so Access may ask for the parameter
value as it cannot figure out which one to use.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
richardgsmith said:
Thanks Allen, for some reason I had not tried just inserting the
[TeamName].[tblTeams] field into the query already!

Any ideas why I am prompted with "'Enter Perameter Value' TeamID" when i
switch from design view to print preview? (If I just bypass by clicking ok
this seems to work, but I wondered why I was getting the box in the first
place!)


Kind regards,

Richard.

Allen Browne said:
Create a query using all 3 tables.

Use that query as the source for the report, and you can output the names
form the lookup tables.

message
Using Access 2003 I have a created a simple database to coordinate the
delivery of presentations to teams within the organisation. I have
three
tables [tblteams], [tblpresenters] and [tblpresentations] (field
details
shown below), from which I have created a form (using a query to draw
together the relevant information from the three tables).

From a relationships point of view, there is a one-to-many relationship
between the [PresenterID].[tblPresenters] and the
[PresenterID].[tblPresentations] fields (the same is true of
[TeamID].[tblTeams] and [TeamID].[tblPresentations]).

I have used autonumbers, [TeamID] and [PresenterID], as the primary
keys
in
the [tblteams] and [tblpresenters] tables respctively and have then
used
the
bound column/coulmn count combo-box options to display the team name
and
presenter name on the form (rather than the corresponding ID number).

I now wish to create a report using essentially the same data I have
used
for the form, but do not know how to display the team and presenter
name
instead of the ID number. Can anyone help?

==================
Table outline composition:

[tblTeams]
[TeamID], [TeamName], [ContactName] ... etc.

[tblPresenters]
[PresenterID], [PresenterName], [PresenterPhone] ... etc.

[tblPresentations]
[PresentationID], [TeamID], [PresenterID], [Date], [Time] ... etc.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top