Looking for a simple solution to automatically fill in fields based on prior records. Working with a very simple wine cellar database. So instead of manually entering every single characteristic of every wine, looking to automate entry if a specific wine already exists in the database. More specifically, looking to, for example, be able to enter the wine's name and, if already in the database, automatically fill other fields such as Region, Country, Wine type, Grape, etc. based on previous entries with the same name.
Would appreciate any pointers.