I have a maintenace table with a custom autonumber field. I have
approximately 1000 records in the table. I now want to add another
table, for parts, and link it to my maintenace table by the custom
autonumber. How can I accomplish that?

I suppose in the same fashion as with any other autonumber. What kind of
a problem do you have when linking tables? Or is it the table structure
that you are unsure about?
Pavel

Rhodrey wrote:

I did that. The thing is the autonumber in the new table started at one.
My custom autonumber is at 101000. How do I get the autonumber in the
parts table to be at the same figure as the one in the maintenance table


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

"Rhodrey Shaw" <rhodd_e (AT) hotmail (DOT) com> wrote

Only the table on one side of the relationship should use an AutoNumber. The other
should just use a Long Integer and then you assign those records the same value as
the AutoNumber in the first table.

So do I have to manually assign numbers to all the records, or do I just
add 1 and the rest will follow?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

"Rhodrey Shaw" <rhodd_e (AT) hotmail (DOT) com> wrote

Ordinarily you would have set this up before you added any data and used a
Form/SubForm for the data entry so that the key field would automatically get copied
to the related records in the subform. With pre-existing data you will have to
manually enter the correct number in all of child records.