Howdy all!
I've searched a bit for some guidance on this but I guess I'm not using the right keywords and keep finding relevant but just outside the box results. I'm trying to teach myself Access and hope I can find some patience and mentorship out on the web. I'm pretty decent at figuring out Excel forums and almost feel silly that I struggle with functions in Access that are simple for me in Excel. =( Thanks in advance for direction!
A database I'm building includes locality information and includes three tables - Cities, Counties, States. The Counties table includes a variety of fields - CountyName, StateID (foreign key linked to the States table's two-letter primary key field), CountySeat, CountyDate (year established), Etymology, etc. etc. I would like the primary key in the Counties table to be an autocompleted field generated by joining the text values of the table's StateID and CountyName fields. I.e. The primary key for Jefferson County, Kentucky would be KYJefferson (or perhaps KY-Jefferson).
Can someone advise regarding how to tell the primary key to autofill using an event (I'm guessing after the second of the StateID and CountyName fields have been entered), as well as how (and where exactly) to formulate the field itself to return KYJefferson or KY-Jefferson. (Hopefully this is as easy to do as it is in Excel).
Thanks again =)