Additional records on a query

[r621]

Hello to everybody,

I need a little support about my db that I've created, basically I use it in order to generate script for Autocad for automated drawings, my concern is about the following matter:

With a Query (name : LOOP SCR_2) , after SCR_SEQ 17

I need to insert additional records SCR_SEQ 18 and 19 which are additional autocad commands like : SAVE and 1
This operation shall be repeated every 3 Addresses e.g. 3,6,9

The desired result shall be:

I've enclosed my DB in order to have a better understanding.

Thanks to who will help me

 

[jdraw]

Not sure I understand. Here is an interpretation. I made a copy of SCR_1.
If you modify SCR_1 to


Your current Loop SCR_1 will produce 18 and 19 records like this throughout your data.

 

[r621]

Hello jdraw, I need to insert records 18 and 19 for the Address_T 3,6,9 etc. every 3 address I need to insert record 18 and 19

 

[arnelgp]

i created small queries first (qryZA, qryZB, qryForUnionZA, qryForUnionZB).
the made a union query (LOOP SCR_1 FINAL) creating union on 3 queries (see LOOP SCR_1 FINAL on design view).
the final query is LOOOP SCR_1 FINAL.

 

[r621]

Thanks a lot arnelgp!