I have a table (Table 1) with a list of job numbers (primary key) in column 1, and corresponding site names and client names in columns 2 and 3.
I then have another table (Table 2) which I want to store all the sales data in.
So I want a form where users can select the ‘job number’ (from Table 1) and then the corresponding ‘site name’ and ‘client name’ (from the same row in Table 1’) get added automatically. User then adds ‘sale item’ and ‘cost’, then all gets saved in ‘Table 2’
Thanks in advance.