I am new to SQL and have tried googling an answer to this but with no luck.

I have the following tables (Simplified):

```
Table1: Transaction
Columns: idTransaction, fkWorker

Table2: Worker
Columns: idWorker (Primary Key, Unique), FirstName, Wage

[fkWorker is linked to idWorker]

```

I want to be able to group more than 1 worker under the same transaction but keep each worker on his own row. 

```
E.g.:
[TRANSACTION TABLE]
[IDTRANSACTION][FKWORKER]

|1            ||Worker3 |

|1            ||Worker4 |

|2            ||Worker3 |

|2            ||Worker4 |

|2            ||Worker1 |

|3            ||Worker1 |

```

Is it possible to do this with Auto Incremental but so it doesn't add to the transaction ID until all workers for a particular project have been added to the table? I've explored the option of adding multiple columns for the worker foreign keys eg. fkWorker1, fkWorker2, fkWorker3 etc. however it becomes to tedious with a large range of workers.

Thank you in advance,

Maxim