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
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