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

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

Hi Jack

Hi Jack

Sorry, didn

Reply | Quote

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

Reply | Quote

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

Reply | Quote

John –

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

Jack

Reply | Quote