can't enter data

[Walter]

I have a States table to store 2-letter state
abbreviations. The states field is primary key. There
are several other fields, foreign keys to other tables.
On the form where I need to use the states field, I was
unable to enter any characters. I checked the properties
of the form and control and found no problems. I then
went to the States table in data sheet view and could not
enter any characters there either. I've checked the
design view of the table and have not seen anything that
should cause a problem. Anyone got any ideas?

Thanks,
Walter

 

[John Vinson]

I have a States table to store 2-letter state
abbreviations. The states field is primary key. There
are several other fields, foreign keys to other tables.

That's a bit odd. That suggests that the States table is on the "many"
side of a one to many relationship to these other tables. That's not
common; more often, you would have a one to many relationship between
States and (say) ClientAddresses. Is this what you actually intend?

On the form where I need to use the states field, I was
unable to enter any characters. I checked the properties
of the form and control and found no problems. I then
went to the States table in data sheet view and could not
enter any characters there either. I've checked the
design view of the table and have not seen anything that
should cause a problem. Anyone got any ideas?

You can't edit the States table ITSELF, in table datasheet view?? Does
this table have any Lookup fields in it?

Just FWIW, my CONtblStates table has the two-letter state (or
territory or Canadian province) postal code as its Primary Key, and
the state name as a text field, and no other fields. Perhaps you're
using your states table in a quite different manner though!

John W. Vinson[MVP]

 

[Walter]

-----Original Message-----
On Fri, 14 Jan 2005 09:46:25 -0800, "Walter"
I couldn't enter data directly into the table either.

The foreign key fields were there because I was trying to
decide how I needed to define my relationships and was
looking at different scenarios. I deleted the table and
recreated it then and was able to make entries in the
State field so I quess there was some glitch in the
original table.
Thanks for your reply,
Walter