Update Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database to track a survey, this is the problem. I can enter data
into all feilds for my tables except one. If I update the form, then go back
I can enter the information into that table. It seems like the table is
waiting for the autonumber to be generated before allowing data to be entered
in that table. Anyone know how to alleviate this?
Thanks!
 
Hi,

can you enter the data directly into the table and it works does the number
get generated for you?

if not the setup an autonumber for the table, the other things to check are
there any fields where data must be entered e.g. 'NOT NULL' because they can
stop data being posted. If you are going to setup an autonumber field it is
advisable to have this as your primary key field.

if you need more help post back here
 
Hello Alex,
Thanks for responding.
Yes I can enter the data directly into the table.
No, I do not have any NOT NULL feilds in the table.
Finally, Yes my autonumber is the primary key for that table.
The form is based on a query that contains all fields from all tables.
However the table I am having this problem with is a many-to-many table,
would this affect it?
 
Hi,

In normal situations the many-to-many table has 2 foreign keys linking to 2
other tables to help with the many to many references, if either of the
values for those 2 fields does not exist in it's related table then the
information will not be updated, as a test copy the database to a new
version that you can abuse, open that database and kill the relationships
and see if you can enter data then.
 
Hello Alex,
Hmmm, well I have disected all the relationships, and the only time I can
update themany-tomany table, is if it is all by itself. I have 5 foriegn keys
in this table connecting it to the other five tables in my database. I can
get around it in a way, by just entering the information in the other tables
on my form, then use shift + enter to update, then fill in the data in the
many-to-many table to complete the form. I even tried to make a new form
coming directly from the tables, but alas still the same problem. I guess I
will just have to be satisfied using shift+enter. Thanks for your help
though, I appreciate it greatly!

Colin
 
Back
Top