New Record script

[Erikj]

HELP! I have 1400 diffrent client IDs which uses the same addressID. I need to create a new record for each client ID with this address ID.

Help Please

[Fitch]

Are you creating related records or what?

[Erikj]

Yes I am creating a related record.

[ESpringer]

ErikJ,

Perhaps the silence is because the task is still not clear. If you write more carefully about exactly what situation you have now -- and exactly what you're trying to achieve -- it might be easier. You mention 1400 client IDs... Well, do you currently have a *record* for each one of these? (I would guess not; otherwise you wouldn't be asking how to create a record for each.) So... in what form do you "have" them? And, do you already have a file with lots of different address IDs, which you want to use as a related file?

Here's one guess: you currently have only ONE file/table, with a client per record, and 1400 of the clients have the same address. Now you realize you want to create a separate address table (which is good because if the address changes, now you can adjust in just one place). Is that right? In that case, you should leave the clients file just as it is and create the new address file. Import records from the clients database, eliminate duplicates, and then set up an address ID for each address. Then you'll need an address ID field in the clients table/file, which can be set up initially to "look up" the address ID based on, say, the street address. After checking to see that the IDs all look right, you can switch over to using the related fields every time the client's address needs to be displayed or printed, etc...

Is this relevant to what you're doing? If not, then it might help if you say more: tell us what your files currently do, what the current problem/need is, etc.