Allowing duplicate value entries

[Guest]

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.

 

[Ed Metcalfe]

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.

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.

 

[Joseph Meehan]

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.

Be definition a primary key is unique.

If you need to have more than one Franchisee name or address, then you
put that information into a different table.

 

[Guest]

Thanks. Understand both replies. Very new to databases.
Regards, Paul.