I have a form/table with an autoid it is linked to a table/form with
and ID as a 1 to many.
Under this form/table I need another table with many records for each
on of the many in the previous table.
form1 form2 form3
table1 table2 table3
autoid -1-------------@ ID -1-----------------@- ID2
of course it won't allow this so I put in a second ID
autoid1 -1-------------@ ID1
ID2 -1-----------------@- ID3
so ID2 is not an autoid based on a record in table 2
but when a sub sub form is built using table3
when a record is created in form2 instead of id2 generating a single
new number to be used in form3 I get 4 blank records.
there is some code under form current and even when its removed I
generate 4 ID2 records that have NO ID1 values
so instead of 1--------1
2
I am getting null 1
null 2
null 3
null 4
I can't think of why I would get 4 records generated in this way since
At first I thought that the sub sub form was generating the records
but I am getting nothing in table1 or table3.
just blank records being generated by the ID2 which is an autonumber.
autonumber-----this got me thinking but what is firing it 4 times ?
I could see 1 since its linked but why 4?