dubliacted record or clon record

  • Thread starter Thread starter MUHAMAMD SALIM SHAHZAD
  • Start date Start date
M

MUHAMAMD SALIM SHAHZAD

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
 
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
Click to expand...

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.
 
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
 
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
 
Back
Top