Key Violation in Append Qry

  • Thread starter Thread starter Steve Finlayson
  • Start date Start date
S

Steve Finlayson

I am trying to append 600+ rows of data to a table - in two fields.
One is a text field and I think not the problem. The other is a Long
Integer field. This field uses th e lookup wizard to show the property
name but stores the primary key for the property. When entering data
in this field, the lookup wizard shows a dropdown listing of the
available records in the property table allowing the selection of the
correct property.
I am trying to append the property number (primary key value in the
property table) and additional descriptors for the property - the text
values.

1. Is the lookup the problem?
2.Can I remove the lookup and append the data and then reinstall the
lookup? Will the lookup work after this is done?
3. If I take the lookup off and append the data, will the table then
reshow the property name while storing the number when the lookup is
reinstalled?

I really appreciate any help I can get on this. Thanks
Steve
 
Steve, the lookup in the *table* is more trouble than it's worth. Best idea
is to dump it, i.e. open the table in design view, select the field, and on
the Lookup tab of the lower pane, set the Display Control to Text box.

In your form, you can still use a combo box to select data. You can even
display the form in Datasheet view so it looks like the table if you wish.
But in the table itself, you won't have the problems you are describing.
 
Back
Top