dubliacted record or clon record

[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

[jmev7]

Re: dubliacted record or clon record

msssd786@yahoo. ca (MUHAMAMD SALIM SHAHZAD) wrote in message news:<5a7850d5. 0402240353.2ab3 ba44@posting.go ogle.com>...[color=blue]
> 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[/color]

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.

[MUHAMAMD SALIM SHAHZAD]

Re: dubliacted record or clon record

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

[Larry Linson]

Re: dubliacted record or clon record

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" <msssd786@yahoo .ca> wrote in message
news:5a7850d5.0 402242137.44977 ee8@posting.goo gle.com...[color=blue]
> 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[/color]