K
Karl Burrows
I ended up adding a bunch of fields to a table with many of them using
duplicate information (Street Name, City, State, etc.), so I used the Table
Analyzer to "normalize" the table. Everything split fine, but now if I
change a value in one record, it changes them all. I also need to be able
to add new values, which it will not let me do.
The form uses a query from the table to sort the records, so I'm not sure if
that has anything to do with it. Do I need to update the query or is there
something else I need to do?
Thanks!
duplicate information (Street Name, City, State, etc.), so I used the Table
Analyzer to "normalize" the table. Everything split fine, but now if I
change a value in one record, it changes them all. I also need to be able
to add new values, which it will not let me do.
The form uses a query from the table to sort the records, so I'm not sure if
that has anything to do with it. Do I need to update the query or is there
something else I need to do?
Thanks!