Forms updating tables correctly

[groovyjoker]

Hello all. Hope I describe my problem correctly.

I have a near complete database with forms linking to tables. Tables have relationships with keys set to ref. integrity/cascade records.

Here is the problem -

My forms are meant for people to input data into these tables. However, I do not want them to change those keys.

Problem 1) If I set primary/foreign keys to "autonumber" I cannot get the relationships to recognize ref. integrity and the records will not cascade, and will not update.

Problem 2) If I set primary/foreign keys to "double integer" then if someone enters a new record into the forms, it is recorded as "zero" when it should be updating in numerical order (I have 479 records in the database, so the next new record should be 480).

Problem 3) If I change it any other way - from double integer or auto number, the tables do not update at all, or do not update correctly.

What is going on here? I thought creating forms was a fairly simple task - create the form, it is related to the table, update the form, it updates the table. I mean, duh.

Thanks anyone for your help, because Microsoft's site sux.

 

[RuralGuy]

AutoNumber fields are Long Integers. Set PrimaryKey fields to AutoNumber and ForeignKey fields to LongInteger.