Updating tables in a database
What is the best way I can go about to accomplish this?
if so, what are the 'licensed' ways to update database tables?
I have a cloned of my production database on another server, let say server 2.
Lookup field many times confuses the new access users because list of items appears in one location but data can be placed in another location.
So it’s important to remember one that while you are updating a lookup field, you need to update the source table. Check out the form properties to make sure that the table in which you are saving the data must be a source.