Inserting multiple rows using a value in a field

[z1efuller1]

I am trying to convert a job listing requisition into several job postings i.e.



Job_Req (Table)
Company_ID Job_Title No_of_Positions
1 Sales Clerk 12

I need to know what I need to use in my query to get this...

Job_Posting (Table)
Job_ID Company_ID Job_Title
1 1 Sales Clerk
2 1 Sales Clerk
3 1 Sales Clerk
4 1 Sales Clerk
5 1 Sales Clerk
6 1 Sales Clerk
7 1 Sales Clerk
8 1 Sales Clerk
9 1 Sales Clerk
10 1 Sales Clerk
11 1 Sales Clerk
12 1 Sales Clerk

Any help would be appreciated.

Thanks

[z1efuller1]

Found a ugly work around for this by creating a table which lists the numbers as many times as thier value..i.e.

No_Positions:Table

No_Pos
1
2
2
3
3
3
4
4
4
4 (and so on...)

when you run the query of postings and join this table on the number of positions available it generates the correct information I was looking for.

However, if anyone knows a coding work around that does not cause me to need the No_Positions Table I would appreciate it.