I have a table called [Mall Information]. In this table I have two fields called "Mall Number" and "Mall Name". How do I get the "Mall Name" field to auto populate with the correct Name when the corresponding "Mall Number" is selected.
I have another table in my database called [Mall Numbers] that has the list of each corresponding Mall Number and Mall Name. Is there a way to get the field to look at that table and autopopulate my field in the [Mall Information] table?
I know how to run an update query, however I'm looking for a way to update the table while you are entering the data without having to close out of the table and run the update query.