Forum Discussion
Append Query (does not work when primary query is empty)
I have two queries which may or may not return rows. However, if the primary query is empty then when a refresh is issued there is an error Column 'anycolumn' in Table 'primaryTable' contains blan...
Can you post a picture of the appended query result and the relationships correlated to the table "PrimaryTable" in your case?
I am getting the same exception while appending two tables.
Column 'column 2' in Table 'Current table' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
I have made sure that there are no null on primary columns but there are column which has null in current table. I do not understand why does that impact in append ?
Please help me understand this issue.