Everyone,
I have a challenging situation and have not been able to read where anyone has encountered this situation. It is as follows:
1. I need to create a Transfer of Bond Information. The Main table is the Member table with a primary key of Mbr_Bond_Number.
2. The 2nd table is the Transfer table. I need to have a Trans_Bond_Number_From and Trans_Bond_Number_To. Unsure if these
should be created as Primary or Foreign keys? Since the value in them will both link back to the Primary Key of Mbr_bond_Number.
3. I want to create a Combo Box for the user to Select who to transfer the Bond From. Then move in other fields from the Member
table, i.e. Bond Name, Last Name, First Name to fields on the From_Side.
i.e. Trans_Bond_Nbr_From, Trans_Bond_Name_From, Trans_Bond_Last_Name_From and Trans_Bond_First_Name_From.
4. Then I will have a second Combo Box for the user to Select who to transfer the Bond To. Then move in other fields from the
member table on the To side.
i.e. Trans_Bond_Nbr_To, Trans_Bond_Name_To, Trans_Bond_Last_Name_To and Trans_Bond_First_Name_To.
5. When the user Clicks on the "SAVE" button, the information is written to the Transfer table and then goes back and performs
a "DELETE" on the Member table, using the Trans_Bond_Nbr_From as the key to delete the record in the Member table.
Can someone plz help me with this? If I were doing this in Cobol with DB2, it would be a none issue, but in Access 2010, I am
getting confused of how to create the Transfer table, setting up the combo boxes and then getting the values in place and performing
the code. Any assistance wuould be greatly appreciated!
Thanx in advance.
Jerry