Adding a field from one tbl to another tbl

[byteme67]

I don't know if I am asking this correctly or accurately. I currently have one table called tblTicketData and one of the fields in this table is called StName (Street Name). I want to send the StName to another table maybe we call it tblStreetName. Here's the kicker. I want to be able to recall the tblStreetName into the tblTicketData and if the StName doesn't exist it will be added and update the table tblStreetName. But if it does exist obviously it doesn't update but it will allow me to not misspell the street name.

So I don't know if this would be easy but any suggestion would be helpful. Also I somewhat new to this.

[June7]

If you want to add new records to tblStreetName 'on-the-fly' during data entry, use a combox to select StName and use code in its NotInList event. Common topic.

Review:

https://blueclawdatabase.com/notinlist-event-code/

http://www.fontstuff.com/access/acctut20.htm