Haven't done much with Access in a long time.
I have a Report that I want to add a field to. It's a text box meant to display some data from a different table other than the one the Report is tied to.
The table is use is called "PrimaryData" and the second table is called "NamesOnly"
Both tables have a field called "Username" and the second table only has a field called "Companyname"
I want this Report box to display the value (it's a string..) of Companyname from the second table, based on what the Username is.
I think the basic idea for the text box Control Source is:
=[NamesOnly]![Companyname]
but how to specify the condition, "WHERE the Username on the same record determines which [Companyname] to display..."
Sorry if this is unclear. I have some decent experience with SQL, but am really not familiar with how to express this stuff in Access.
TIA for your suggestions!