Using a union query to enter data

[Annnnn]

Hi,
I hope you guys can help me out with a probably simple question
I have a union query that searches for a sample ID in two different tables. The results of this query is presented within a subform. Subsequently, I would like to be able to also enter data in one of the columns. I am able to do this in other subforms based on queries, but somehow with this form I am not able to do it. The only reason I could think of is that it is because it is a union query, is this true?




And if so, is there a solution?

Tnx!

[June7]

Yes that is true.

[CJ_London]

use of union queries is usually indicative of poor table design in that you are effectively using the table name as a field

Why don't you have just one table with an extra column to include the table name (or to be more precise its meaning).

[orange]

Annnnn,
Further to the comments so far, could you give readers an overview of your requirements in simple English -no database jargon?
You mention UNION query, and subform -but no mention of the form, nor tables.
You may get more focused responses once people understand what you are trying to accomplish with more info and context.
Good luck with your project.

[Annnnn]

Thanks guys,
When I made the second table I already realized this was probably not the best option. I did this because I have old data where there are a few column that are different from the new table that I want to use.
However it made it to complicated so I just merged the two columns and this solves a lot of the problems