duplicate record in 2 tables

[SHETTY]

Dear Sir,

I want to duplicate a invoice entry

In my invoice entry form there is one sub form for items (item log)

Main table bill & bill log are linked with Bill ID which is promery key in
the table 'Bill'

Kindly advise how I can duplicate one record including records of sub table

We need to change only 2 fields Viz bill no & bill date, rest of the data in
both the tables will be almost same

Please guide


Thanks & regards

Ramesh Shetty