I have a view in which I want to join two tables, but each time I try doing a join, I get an error message saying it is not donw.
I have a table (tblTrailer) with 4 fields. TrailerID (auto); TrailerLic (Text, because License Plate have alpha); Trailer #; Trailer Carrier
The other table (tblWashInfo) I have a number of fields of which WashLic# (which is a text field), but in my DataPage, uses a pull down from tblTrailer).
What I ultimately want is for the user to select the License # and have the carrier name and trailer number appear on the screen.
But when I change my field types (in table) and then try to Join I get the error.
Thoughts on design? As I write this, I think my table design is incorrect, but your thoughts are appreciated