Hey great info everyone - even though I know I'm a little late to the party. So far it works perfectly. What I'm trying to do is verify whether a street address has been previously inputted or not.
Checking UNIQUE works just fine when the address is all contained in one input box (on html form) and one row of the table, but I'd like to standardize it a bit more with street address, city, state, country, zip all having their own input box (on the html form).
I'm wondering what is the best practice for something like this. Would I have each html field as a populate a separate row in the table? Or could I combine all the data from the different input boxes (of the html form) and have them populate one row in the table?
Thanks in advance,