Hi,
i am copying data and pasting it from Excel manually to subform.
After pasting i want to trigger append query and all IDs from pasted records insert into corresponding ID in junction table.
(many to many relationship).
What event should i use and how to show Access that i paste 5 new records with specific IDs.
So assume i have student1 and i want to assign him to 3 different classes with specific set of attributes.
For classes i am inserting 3 records with attributes, automatically i have IDs thanks to autonumber field in tblClasses.
And with these pasted new records IDs, for example 1,2,3 i want to assing it for Student1 with ID 1.
So i will have 1, 1
1,2
1,3 in junction table.
How can i achieve that?
Best,
Jacek
i am copying data and pasting it from Excel manually to subform.
After pasting i want to trigger append query and all IDs from pasted records insert into corresponding ID in junction table.
(many to many relationship).
What event should i use and how to show Access that i paste 5 new records with specific IDs.
So assume i have student1 and i want to assign him to 3 different classes with specific set of attributes.
For classes i am inserting 3 records with attributes, automatically i have IDs thanks to autonumber field in tblClasses.
And with these pasted new records IDs, for example 1,2,3 i want to assing it for Student1 with ID 1.
So i will have 1, 1
1,2
1,3 in junction table.
How can i achieve that?
Best,
Jacek