Naqibullah
Registered User.
- Local time
- Today, 22:21
- Joined
- Feb 7, 2013
- Messages
- 86
Dear respected colleagues,
i want to insert a group of records into a table at once.
i have three tables i.e. Group, Member, Saving.
the relationship between tables is: group to member (1:M), member to saving 1:m and there is no relationship between group and saving.
every group has maximum 20 members, and every member does saving once every month. since the amount of saving of every member of a specific group is same. i want to have a query to run every month to automatically insert all primary keys of specified group's members, amount of saving and the date of saving in Saving table. (currently i am doing this job manually every month). and in case some member does not have saving, then i will manually change it to zero.
i hope i well explained the scenario.
thanks from your support in advance.
i want to insert a group of records into a table at once.
i have three tables i.e. Group, Member, Saving.
the relationship between tables is: group to member (1:M), member to saving 1:m and there is no relationship between group and saving.
every group has maximum 20 members, and every member does saving once every month. since the amount of saving of every member of a specific group is same. i want to have a query to run every month to automatically insert all primary keys of specified group's members, amount of saving and the date of saving in Saving table. (currently i am doing this job manually every month). and in case some member does not have saving, then i will manually change it to zero.
i hope i well explained the scenario.
thanks from your support in advance.