There are a couple of ways you could manage that.
One would certainly be an on-insert trigger. Another would be to handle it in the insert proc. More likely, you'd limit it in the application, not the database. If there are only two fields for entering addresses on the screen, you can only really enter two addresses.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon