create record in one table and update junction table at the same t

create record in one table and update junction table at the same t

Post by R2Fye » Fri, 03 Nov 2006 06:06:03


I have a two tables, obligations and instruments. I have a junction
table(obl_inst) to create a many to many between those two tables. My main
form is instruments and obligations is a subform. If neither table is
populated and I add an instruments record thru the instrument form then I
need to put data in the obligation subform which updates the obligations
table ..... and I can't get it to populate the junction table at the same
time. Is this possible and if so how. Thanks!
 
 
 

create record in one table and update junction table at the same t

Post by TmV0d29ya1 » Fri, 03 Nov 2006 11:30:02

well yes - you need your design so that you populate the data also to the
junction table. Nothing embedded within Access does that for you per se...

the classical many-to-many case is a school. Many students, many classes.
The junction table cross references. In general the student population is
fixed (at least once per school year) and the available class set is fixed.
So those two tables, once populated, don't change much within a semester or
year.

all the action is in populating the junction table.

in your case it sounds like you are actively populating all 3 tables at the
same time. which is ok too - but the junction table is not
autopopulated...your form design needs to figure out an efficient way to
accomplish that from the end user perspective....

--
NTC