Address Database doesn't allow duplicates in zip code column

Creating tables and queries

Address Database doesn't allow duplicates in zip code column

Postby egildone » Wed Dec 02, 2015 6:56 am

I created a database of addresses and a labelfile to be used to print mailing labels, but when adding records it doesn't allow duplicates. I need to modify the zip and zip+4 fields to allow duplicates, but can't figure out how to do this. Can someone help me with this?
Edward Gildone Open office 4.1.2 Windows 10
egildone
 
Posts: 1
Joined: Wed Dec 02, 2015 1:44 am

Re: Address Database doesn't allow duplicates in zip code co

Postby F3K Total » Wed Dec 02, 2015 10:22 pm

Hi,
can you show how you defined that table?
R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 974
Joined: Fri Dec 16, 2011 8:20 pm

Re: Address Database doesn't allow duplicates in zip code co

Postby RoryOF » Wed Dec 02, 2015 10:32 pm

That suggests you may have made the zip column as the primary key.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31400
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 3 guests