I can't figure this out. I have a one to one set - ContribRecords.set. I enter donation records in the Contribution Table. The Contributions are linked to a Record Table that contains all my potential donors.
I have a form set up that has the Contribution records at the top and when I pull one of the donors from the Record table to put in the Contribution I do it by Id Number. Below the Contribution to double confirm and make adjustments if necessary on the fly I have a tabbed form of the information in the Records Table for the specific Id Number.
When I pull up an individual to put in a new donation voila all their information appears in the tabbed form.
Everything works great unless I want to make a change in the tabbed form. For example lets say I want to add a spouse name , change an address or something. Once I click the tabbed form and begin a change all the information except the id number is erased in the tab form and new record with the same id number is begun in the Record Table. I don't want to make a new record in the Record Table, I just want to edit it. I was able to do something similar in Alpha Four (I know, get a life and get out of DOS) and was trying to make something similar.
What have I done to cause my problem here. If I don't try to make changes to the tabbed form on the fly all is well, it just happens when I attempt to make the change.
I have attached a screen shot of the form to give an idea of my form that I am using for data entry.
I have a form set up that has the Contribution records at the top and when I pull one of the donors from the Record table to put in the Contribution I do it by Id Number. Below the Contribution to double confirm and make adjustments if necessary on the fly I have a tabbed form of the information in the Records Table for the specific Id Number.
When I pull up an individual to put in a new donation voila all their information appears in the tabbed form.
Everything works great unless I want to make a change in the tabbed form. For example lets say I want to add a spouse name , change an address or something. Once I click the tabbed form and begin a change all the information except the id number is erased in the tab form and new record with the same id number is begun in the Record Table. I don't want to make a new record in the Record Table, I just want to edit it. I was able to do something similar in Alpha Four (I know, get a life and get out of DOS) and was trying to make something similar.
What have I done to cause my problem here. If I don't try to make changes to the tabbed form on the fly all is well, it just happens when I attempt to make the change.
I have attached a screen shot of the form to give an idea of my form that I am using for data entry.
Comment