i’m sure this is the most elementary of questions / problem. but, here goes…
i have a database that has data in 2 tables. i want to pull 2 fields from one table and 1 field from another table with the field “patron_id” being the primary key that is in both tables.
i want to have someone enter the “patron id” into a text box. at that point, the Patron’s First & Last name will appear along with one other piece of information.
what’s the query i would use?
