Re: Copy a record in a form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi TC

I work for an insurance company and I created a database to track claims.
This is all in one table the fields are:

Policy Number
Insured
Date process
Comments

What my user wants is instead of re-typing the policy number, insured, date
process, comments the user simply press the copy command button making a new
record, but within my code I will delete the date process and the comments
making those fields null. Unfortunately there is no primiary key. All I
want to do is just copy the record and making a new record. Any tips will
be appreciated. Thank You..




"TC" <aatcbbtccctc@xxxxxxxxx> wrote in message
news:1142914772.711990.96330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Not to answer your question, but: you generally should /not/ copy a
record into a new record.

Instead, the data that is common to both the records, should be stored
in a seperate table. So, your current table structure might not be
correct.

If you want some comments on your table structure, show us the name of
each table, and list the fields in each one. (You nedn't show their
typres & lengths.)

Also, tell us what is the "primary key" of each table. If you don't
know what that is, you need to research that term! It is one of the
main concepts in a relational database like Access.

HTH,
TC (MVP Access)
http://tc2.atspace.com



.

Relevant Pages

  • Re: confusing relationships
    ... Even if some of the people in your database will never be policyholders, ... Do some of these named spouses also have multiple spouses whom you need ... Is exactly one insured person named on each policy? ... ..i have another table which has all policy types (time periods ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Getting database value into a rule policy
    ... You need to have a variable of type Dataconnection ... instances in the composer or orchestration. ... I don't see where I can send a database ... but my policy only works in testing. ...
    (microsoft.public.biztalk.general)
  • RE: Database Corruption after Exchange SP 2
    ... I repaired my Exchange database successfully and I can perform backups ... A conflict in Group Policy can cause these events to occur. ... Windows XP to configure domain policies, you may find that the policies do ...
    (microsoft.public.windows.server.sbs)
  • Re: Restated: "Fields are expensive, records are cheap"
    ... I understand the issue of disk access quite complex given all those issues ... I did not realize that database actually kept track of where each field ... Between the policy information, reinsurance tracking, state, federal, rate ... policy master table had well over 200 fields in it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: OO vs. RDB challenge
    ... >> policy is ensured by to be valid by the property set method. ... version might be okay in the simplest of requirements. ... are the one who was *insisting* on not adding unnecessary complexity, ... they are implemented in the database is because it is too inefficent to send ...
    (comp.object)