gsanghvi20
New member
- Local time
- Today, 16:46
- Joined
- Jul 29, 2008
- Messages
- 5
Hi All,
I have 2 tables called tblManagerInfo and tblFundInfo. tblManagerInfo and tblFundInfo have a one to many relationship on ManagerName. FundName along with the ManagerName is the PK for tblFundInfo and ManagerName alone is the PK for tblManagerInfo. Now I have 1 form to fill out info of Managers and then on clicking Add Fund button it has to add another fund in the tblFundInfo table with the Manager Name being the the one which I have in the ManagerName text box. Both these forms are bound forms to the respective tables.
The problem is that, that every time I add the Managername, it adds a new Manager name in the ManagerInfo table, but when adding Fund, it essentially goes to the first record on the tblFundInfo table and changes that record - essentially deleting the record and putting a new record under the new ManagerName.
Please let me know what is happening. I am sending the snapshot of the macro code I have used for the Add Fund button.
Thanks,
gsanghvi20
I have 2 tables called tblManagerInfo and tblFundInfo. tblManagerInfo and tblFundInfo have a one to many relationship on ManagerName. FundName along with the ManagerName is the PK for tblFundInfo and ManagerName alone is the PK for tblManagerInfo. Now I have 1 form to fill out info of Managers and then on clicking Add Fund button it has to add another fund in the tblFundInfo table with the Manager Name being the the one which I have in the ManagerName text box. Both these forms are bound forms to the respective tables.
The problem is that, that every time I add the Managername, it adds a new Manager name in the ManagerInfo table, but when adding Fund, it essentially goes to the first record on the tblFundInfo table and changes that record - essentially deleting the record and putting a new record under the new ManagerName.
Please let me know what is happening. I am sending the snapshot of the macro code I have used for the Add Fund button.
Thanks,
gsanghvi20
