Append Query Headache!

[Guest]

Ok, I have an apend query that basicly copys everything Ineed from one table
to another in another DB. It works, except where I have combo boxes on both
tables. The combo box fields are not coming over in the append query, but
everything else is.

What do I need to do to make this work?

 

[Ken Snell [MVP]]

The combo box fields? Combo boxes don't really have fields, so perhaps you
mean the values in the combo boxes?

Perhaps you could explain more details about how your form fits in with your
append query, what the append query's SQL statement is, what you want to
accomplish, and what is specifically not working.

 

[Guest]

I meant the fields are lookups that lookup values in other fields. These
fields will not append to the other table. The other table has lookup values,
but they dont lookup other tables, (created by someone else). But they are
both the same value.

Anyway when I run the append query it copies everything I want except those
lookup fields.

I cant post the SQL because the computer with the DB doesnt have internet
access.

 

[Jeff Boyce]

If you are indeed talking about tables, your "combo boxes" are probably
lookup field data types. Check the tablesdbdesign newsgroup for the many
reasons NOT to use that data type. You may have just added a new reason to
the list.

Jeff Boyce
<Access MVP>

 

[Ken Snell [MVP]]

So what you see in the lookup field is not what is actually there. And you
probably are trying to append the wrong "data" to the new field.

You'll need to give us more information about the tables' structures, what
the data types are for each field, what the Row Source of the lookup fields
are in the tables, and so on. And we probably will need to see the query's
SQL to help you out here.

--

Ken Snell
<MS ACCESS MVP>