If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleted then added record won't show in form
A record was deleted from an owner table which has a property table related
to it. I couldn't add it back using the form, but could in the table. Now the record exists with a different record number in the table than in the query & won't show at all in the form. Also, the property form will not accept a new property. I'm a rare user, but someone wants to pay me to fix this problem & I created it, trying to see what happens when a deletion is made. Thanks in advance. |
#2
|
|||
|
|||
Deleted then added record won't show in form
I created it, trying to see what happens when a deletion is made.
Next time play with a copy. You will have to manually go into the property table and change all the records that have the old owner reference. BUT FIRST BACKUP BUT FIRST BACKUP Run an unmatched query on the property table and verify the all the property without a match belongs to that one owner. You should be able to use an update query withj old owner designation as criteria and update to new. -- Build a little, test a little. "Shannon" wrote: A record was deleted from an owner table which has a property table related to it. I couldn't add it back using the form, but could in the table. Now the record exists with a different record number in the table than in the query & won't show at all in the form. Also, the property form will not accept a new property. I'm a rare user, but someone wants to pay me to fix this problem & I created it, trying to see what happens when a deletion is made. Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|