Help, I'm getting rusty.
When I make an entry into this query it puts a new ID into the new record in tblClientsOnBoarding - which is understandable.
I want the ID from tblContacts to be used. How do I do that?
Need to use existing ID
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Need to use existing ID
You do not have the required permissions to view the files attached to this post.
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Need to use existing ID
Dang. I had the ID on tblOnBoarding set to AutoNumber. Changed to Long and we are cooking.
Sorry to trouble you all.
Sorry to trouble you all.
Avagr8day, regards, Peter
-
- StarLounger
- Posts: 81
- Joined: 22 Feb 2022, 09:04
Re: Need to use existing ID
I would still have an autonumber field, just not all called ID.
I would have another field, Long as you indicated for the foreign key.
I would have another field, Long as you indicated for the foreign key.
Using Access 2007.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Need to use existing ID
Thanks Gasman. (does that mean you have gas? )
I only want 1 ID, no need for anything else to delineate each record. On top of that, it is working - well so far.
I only want 1 ID, no need for anything else to delineate each record. On top of that, it is working - well so far.
Avagr8day, regards, Peter