Many to one relationships/record population?

[Tommy B]

Hi Guys! Its a while since I had a post...life has been quite ;-) But that never lasts long at work does it!

So here is what I am trying to do:

I work in telcoms and need an automated system for provisioning new numbers. What I need is a two table system, the first table uses an autonumber ID, but needs to apply this ID to mulitple records in the second table...so if I have two number fields in the first table that act as a range i.e. 2000(first number field) and 3000(second number field), which the first table see as one record with one autonumber, and then have an append or make table query which will populate all numbers in the range as seperate records in the second table, but obviously using the master provisioning number against all. I know this sounds v.complex, and is probably not possible...but as always any manna from above would be gratefully recieved

Cheers,

Tom.

 

[Tommy B]

Yep. Its the code for autogenerating a range of numbers that I really need. Although the information you just gave is very useful too...thanks

Would be great if you could help me out!!!

Tom.

 

[Tommy B]

Thanks for this Pat...I will play around with the idea and see what happens

As always I greatly appreciate the help!

Tom.