I have several "lookup-wizard" text fields on a master form - that refer to different tables that were built for ease of input (i.e., looking up a customer's name, department, location, etc.)
When someone types in the beginning portion of a name, it auto-fills the rest of it. Great.
But, when someone enters a NEW name (not in the look-up table), is there a way to automatically update the look-up table with the new record? Yikes! This one sounds like it might be complicated.