By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

dubliacted record or clon record

P: n/a
dear respected sir,

i would like to ask you following problem to anyone can give me hints

- i have database of insurance company, where policy table is link to
customer table and each policy has details policy table
- now the pk in poicy table is policyno(pk)
- so every year the same client policy came for renewal, so v need to
design database form/query/programming/sql that will copy the the
whole row or record, then policyno need to change
i did try by dubplicate wizard button could not success, then i try as
well append query with where clause also fails

i felt i am stuck in syntaxing...can any one help me

thanks a lots

urs student

shahzad
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ms******@yahoo.ca (MUHAMAMD SALIM SHAHZAD) wrote in message news:<5a**************************@posting.google. com>...
dear respected sir,

i would like to ask you following problem to anyone can give me hints

- i have database of insurance company, where policy table is link to
customer table and each policy has details policy table
- now the pk in poicy table is policyno(pk)
- so every year the same client policy came for renewal, so v need to
design database form/query/programming/sql that will copy the the
whole row or record, then policyno need to change
i did try by dubplicate wizard button could not success, then i try as
well append query with where clause also fails

i felt i am stuck in syntaxing...can any one help me

thanks a lots

urs student

shahzad


I think you're going to need to give more details, such as which table
you are trying to duplicate a record in (I'm assuming it's the policy
details table), and what are the indexes (especially, describe unique
indexes: primary key, etc). Then, it may be more possible to assist
you in this.
Nov 12 '05 #2

P: n/a
dear sir, in fact i do need to dubplicate

policy master table
policy details table, as there r relations ship

well i have done successfully by the wizard of dublicate button, but
still i wish to give alert or popup to change policyno(pk) in master
table/details as well

there can be used by dao, ado and any other source that i don't know

i saw the codes from various site could not clear me, they created
book mark

rgds, and thanks
shahzad
Nov 12 '05 #3

P: n/a
If you need to change the policy number every time the policy is renewed for
another time period, there is something wrong with your design. The policy
master record should remain, unchanged, and its PK should be a foreign key
in the related tables, each of which should also have its own record key. I
would regard payment of a premium as just another transaction against the
policy, and would have a separate table for transactions (payments in,
payments out, etc.) -- that may be the purpose of the policy detail table in
your schema.

Larry Linson
Microsoft Access MVP

"MUHAMAMD SALIM SHAHZAD" <ms******@yahoo.ca> wrote in message
news:5a**************************@posting.google.c om...
dear sir, in fact i do need to dubplicate

policy master table
policy details table, as there r relations ship

well i have done successfully by the wizard of dublicate button, but
still i wish to give alert or popup to change policyno(pk) in master
table/details as well

there can be used by dao, ado and any other source that i don't know

i saw the codes from various site could not clear me, they created
book mark

rgds, and thanks
shahzad

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.