How to add data from key fields to intermediate table while adding data to other tables?

Question

SQL

I need to insert data into these three tables, but in the Orders_Services table, all fields are key fields of other tables. How would I get them when pasting?

Answer 1

To solve my problem, I used the DMax function. They told me here .

Answer 2

Hang a trigger on Orders_Services.