I have various fields doing lookups on a form in the following order:
Location - Category
Sub Locaton - Subcategory
All working fine using a lookup view and a mixture of @dblookup and @dbcolumn
Now for all these field, I am allowing the user to enter values not in the list but I want this value to be updated in the lookup view(Keyword form) so that when the client selects this same location next time, the newly added value(by client) will be in the list of sub location without the administrator having to update the keyword form manually. Is this possible?