N
Niklas Östergren
Hi!
I have a Q (B) which is based on another Q (A) and a table (tblC). I have
created a relationship between QB and table tblC (autonumber field).
It seams that it´s not possible to add new records into any of the tables
involved. And to be able to add new records I need to create a completly new
query using all tables and criteras as I already have in QA.
Is this the way it sopose to work or am I doing something wrong here? Is
there a way around this?
It would be so nice to just have ONE QA and then base several other Q on
this to be used as recordsources for form´s. Which is the case with QB (I DO
have other names on my queries but to simplifye this msg I renamed them to
QA and QB).
TIA!
// Niklas
I have a Q (B) which is based on another Q (A) and a table (tblC). I have
created a relationship between QB and table tblC (autonumber field).
It seams that it´s not possible to add new records into any of the tables
involved. And to be able to add new records I need to create a completly new
query using all tables and criteras as I already have in QA.
Is this the way it sopose to work or am I doing something wrong here? Is
there a way around this?
It would be so nice to just have ONE QA and then base several other Q on
this to be used as recordsources for form´s. Which is the case with QB (I DO
have other names on my queries but to simplifye this msg I renamed them to
QA and QB).
TIA!
// Niklas