Greetings and Happy New Year all.
I'm having a problem with using a Lookup to bring the Customer ID and Customer's name from a Customer's Table into a Products table.
So in the Products table, I have a lookup field:
SELECT tblCustomer.CustomerID, [Lastname] & ", " & [Firstname] AS CustomerName FROM tblCustomer
With the bound column = 1, a column count of 2, and column widths of 0" and 1".
This works fine for Showing the Customer name, but I also need to show the CustomerID in this table.
I can reverse the column widths to show only the CustomerID but for some reason it will not show both.
And if I add another field with basically the same SELECT statement, it always shows up blank, no matter
what I try.
I've researched and finagled (technical term) this since last year (literally) but no luck or clue yet as to how to proceed.
As always thanks in advance for any suggestions.
I'm having a problem with using a Lookup to bring the Customer ID and Customer's name from a Customer's Table into a Products table.
So in the Products table, I have a lookup field:
SELECT tblCustomer.CustomerID, [Lastname] & ", " & [Firstname] AS CustomerName FROM tblCustomer
With the bound column = 1, a column count of 2, and column widths of 0" and 1".
This works fine for Showing the Customer name, but I also need to show the CustomerID in this table.
I can reverse the column widths to show only the CustomerID but for some reason it will not show both.
And if I add another field with basically the same SELECT statement, it always shows up blank, no matter
what I try.
I've researched and finagled (technical term) this since last year (literally) but no luck or clue yet as to how to proceed.
As always thanks in advance for any suggestions.