If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display name on report instead of corresponding autonumber identif
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. |
#2
|
|||
|
|||
Display name on report instead of corresponding autonumber identif
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "richardgsmith" wrote in 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. |
#3
|
|||
|
|||
Display name on report instead of corresponding autonumber ide
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" wrote: 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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "richardgsmith" wrote in 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. |
#4
|
|||
|
|||
Display name on report instead of corresponding autonumber ide
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "richardgsmith" wrote in message ... 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" wrote: 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. "richardgsmith" wrote in 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. |
Thread Tools | |
Display Modes | |
|
|