Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    Duplicate Value in Index Question

    A2k (9.0.4402) SR-1

    What is the best approach to duplicate a record that has a primary key?

    I have the Duplicate Record Wizard built button on the form:

    When I get the

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    Most everyone works very hard so a database does not have duplicate data so you are sorta swimming upstream. Can you tell us why you want to have duplicate records when this goes against database normalization?

    Jack

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    Hi Jack

    Hi Jack

    Sorry, didn

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    Thanks for the explanation. Big difference!

    Create two tables with a one to many relationship. Customer (the One table) and Permits (the Many table). Create a Form/Subform combination with the Customer table being the basis for the Main form and the Permit table being the basis for the subform. Both tables will have a CustomerID field with the Customer table having being the Primary key and CustomerID in the permit table being the Foreign key. The two forms will be linked on CustomerID. The Permit tables Primary key will be your unique ID for the permit numbers.

    A customer returns needing a new permit. Select him/her in the main form and the subform will show you their history as well as allowing you to issue a new permit with a unique ID.

    Hope I have this all correct and that it makes sense.

    Jack

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    Hi Jack

    Thanks for master, detail exclamation

    These are Parking Permits that are recommended by physicians to deserving patients/customers and are also abused by some customers. The physician, type of disability, customer address information is part of the history.

    So the thought was to keep all data in one record.

    When customer renews or looses Permit, I want to query Permit in question, review complete history, press Duplicate Record button, enter new unique Permit Number, issue date, etc into new record. When I get the

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Value in Index Question (A2k (9.0.4402) SR-1)

    John -

    I have sent a small demo to your email address. A copy is attached here as well.

    Jack
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •