Allowing duplicate value entries

P

Paul

Hope someone can help out with a project assignment and understand the
following explanation of problem:

Currently trying to enter duplicate franchisee and restaurant contract
details into a database and receiving the error code 3022 'entry not
successful due to duplicate values'.

Wondering how I can enter the following duplicated data into the .dbs
successfully:

Franchise No (set as primary key)
Franchisee Last Name
Franchisee Address

Regards and thanks, Paul.
 
E

Ed Metcalfe

Paul said:
Hope someone can help out with a project assignment and understand the
following explanation of problem:

Currently trying to enter duplicate franchisee and restaurant contract
details into a database and receiving the error code 3022 'entry not
successful due to duplicate values'.

Wondering how I can enter the following duplicated data into the .dbs
successfully:

Franchise No (set as primary key)
Franchisee Last Name
Franchisee Address

Regards and thanks, Paul.
Click to expand...

Paul,

Why do you want to?

I cannot think of any reason to want to enter genuine duplicates into a
database table. If you need to this is either a table structure design flaw,
or a flaw in the choice of field(s) for your primary key.

Ed Metcalfe.
 
Top