Surely this should be easy to do [closed]

asked 2017-11-30 15:57:02 +0200

oli@sf gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Ratslinger
close date 2017-11-30 19:06:11.677334

Comments

1

@oli@sf This question is a duplicate of this post. Please do not duplicate questions.

Ratslinger gravatar imageRatslinger ( 2017-11-30 16:47:58 +0200 )edit

sorry I will remove it

oli@sf gravatar imageoli@sf ( 2017-11-30 16:59:16 +0200 )edit