Dear Colleagues,
I would like to please know how I can create multiple rows in a target table please?
For example, I have task table where a set of Task rows in which each one will have state column for a state of a country. The Task will also have a project column too, where each create task will have the same Project name copied into it from a Project Table, along with the State column. So for example: the task table should basically create a task table like this:
KEYID PROJECT STATE
1 Roadwork NSW
2 Roadwork VIC
3 Roadwork QLD
4 Roadwork WA
5 Roadwork SA
6 Roadwork TAS
7 Roadwork NT
8 Roadwork ACT
What is the best way to acheive this if I have a Project Table, as Task Table, and a State Table (containing a range of states) please?
Regards,
Colin
Please check this oneโฆ
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |