Address Database doesn't allow duplicates in zip code column

Creating tables and queries
Post Reply
egildone
Posts: 1
Joined: Wed Dec 02, 2015 1:44 am

Address Database doesn't allow duplicates in zip code column

Post by egildone »

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
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

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

Post by F3K Total »

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
User avatar
RoryOF
Moderator
Posts: 34611
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

That suggests you may have made the zip column as the primary key.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply