My forms will not allow additions and my tables get a + column

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

Guest

My database has 4 tables. Employee, position, postofund (a double key table
for many to many relationship) and a funding table. I am trying to create a
form to update the tables, however the form will not allow updates. The
forms and queries do permit updates, deletions and additions. But the Table
keys are not editable. I cannot find out why. Also, I find tables switch to
a pivot type with no reason. I have had to delete and replace them with
backups to get the plus sign out of the field. Please direct me to someone
who can give me some help with this problem.
 
My database has 4 tables. Employee, position, postofund (a double key table
for many to many relationship) and a funding table. I am trying to create a
form to update the tables, however the form will not allow updates. The
forms and queries do permit updates, deletions and additions. But the Table
keys are not editable. I cannot find out why. Also, I find tables switch to
a pivot type with no reason. I have had to delete and replace them with
backups to get the plus sign out of the field. Please direct me to someone
who can give me some help with this problem.
Click to expand...

What are your Form's Recordsource properties? Are you trying to create
a big Query of all three tables? If so don't; you should be using a
Form based on one "one" side, with a subform based on the junction
table. If you have done so, please post the Recordsource of the form
and the subform, and the master/child link fields.

The plus sign IS NOT A PIVOT TABLE. It's a subdatasheet (a new feature
in A2000). View the table's Properties and set the Subdatasheet to
None (by default it's Auto) to get rid of this performance-dragging
feature.

John W. Vinson[MVP]
 
Back
Top