error on make table query (1 Viewer)

[darcy g]

I am trying to make a table that has the pk from 3 tables
and am getting an error that only one autonumber is allowed, such as 'resultant table not allowed to have more than one Autonumber field'
I really want to keep these fields in the new table.

Any ideas?


thanks,

darcy

 

[David R]

Can you copy them over from where they are Foreign Keys instead? I assume this is some sort of data consolidation table - there's really no point in having three continuously running autonumbers in a table...

 

[darcy g]

Right. I put those in just to keep track of the ID for the other tables. I tried to copy approach by making an update query for after I run the make table query. That works for now, thanks!

but there may be another way to do it at once...

 

[David R]

Not quite what I meant..

Actually, I was assuming that these three tables were linked via their PKs. So what I was wondering was if you could include the FK field from the 'many' side of the link for two of them where they are Long Integers (instead of the 'one' side, where they really are Autonumbers), and the PK from the 'one' side of the one remaining table, you may be able to do it all at once....