Auto Fill Feilds
So I have 1 Table that has many different fields.
I'm looking for a way so that when I type into 1 field, they auto fill other fields when the data matches all records to the original field.
So I have Field called: Job Number.
Lets say when you enter in 319 as the job number, id like it so that the 'client' field and 'product' field match other records that have 319 as the job number.
So that every time I make a new record, I can enter in 319 as the job number and the other fields are already complete with the correct information.
Sorry for being confusing, I'm assuming there is an easy fix to this.