Auto-Population of Fields
I have created a database that I am using to log photographic job details that includes fields such as Location, Job Number and Time taken etc. A number of these fields use drop down value lists to select pre-defined values.
What I would like to do is setup a system whereby selecting a value from one field auto-fills or auto-populates a number of other fields. This is mainly to cut down on input time and also to improve accurate data entry.
Is there an easy way of doing this without using a complicated calculation?