db1 contains 9 fields, 5 are text, 3 are calculated, 1 is relationship. There are approximately 1000 records.
db2 has 4 fields, all text, about 300 records.
I am able to change one of the text fields (price) in db1 to a relationship field (to a field in db2). I get the standard alert that changing field type will cause loss of data.
After the change is made the relationship data shows in db1 and looks correct. However, the two calculated fields that reference the price field now show as 0.
Then I close the db, exit hdb, reopen hdb, reopen db1. After 15 seconds I get a force close. Try agaon, same thing.
Start fresh with a backup, go throigh the process, same results.
Please advise troubleshooting steps.
nook color (rooted)
Nook Color CM7.1