G
Guest
I have two tables a main table and another we'll call Table 2. I joined them
so it says "all records from main table and only records from Table 2 when
they are equal, and matched by ID. There are no records yet in Table 2.
When I make a query or form and go to add information into Table 2, it
overwrites the ID from the maintable with a 0, instead of starting a record
with the ID From the main table as it's ID number.
I have set up these tables before but my expertise is very minimal so I
could have easily set it up correctly by mistake previous times... the only
difference I can see between my other databases and this is that the join
type says one to one on the bad one and it says one to many on the working
database. But I can;'t figure out how to set it to be a 1 to many join.
so it says "all records from main table and only records from Table 2 when
they are equal, and matched by ID. There are no records yet in Table 2.
When I make a query or form and go to add information into Table 2, it
overwrites the ID from the maintable with a 0, instead of starting a record
with the ID From the main table as it's ID number.
I have set up these tables before but my expertise is very minimal so I
could have easily set it up correctly by mistake previous times... the only
difference I can see between my other databases and this is that the join
type says one to one on the bad one and it says one to many on the working
database. But I can;'t figure out how to set it to be a 1 to many join.