G
Guest
Before I ask the question a little background.
I have a querie that is build on One table (Hybe) that has Hybe # as Primary
Key and another table (Hybe Channel) that has hybe # and Channel as Primary
Keys. The Channel can only have two values (Cy3 and Cy5)
Then I build a query that gives my a result for each record, all the
information from Hybe table, the information from Hybe channel for Cy3 and
also for Cy5.
So in the design view of the querie I have the Hybe table once and then the
Hybe Channel table twice, once for each channel.
To link the tables together I use join properties #2
This works fine and I get all the information right.
But then there is the problem, I can't add new records to the query ( or
more in the form based on the query) Why is that ??
Thanks
Karen Jenny
I have a querie that is build on One table (Hybe) that has Hybe # as Primary
Key and another table (Hybe Channel) that has hybe # and Channel as Primary
Keys. The Channel can only have two values (Cy3 and Cy5)
Then I build a query that gives my a result for each record, all the
information from Hybe table, the information from Hybe channel for Cy3 and
also for Cy5.
So in the design view of the querie I have the Hybe table once and then the
Hybe Channel table twice, once for each channel.
To link the tables together I use join properties #2
This works fine and I get all the information right.
But then there is the problem, I can't add new records to the query ( or
more in the form based on the query) Why is that ??
Thanks
Karen Jenny