Prevent Duplicates

[Datagopher]

True enough. I forgot about that. Probably because I have not had a need to use that in a very long time since ideally, you would want to be filtering on an ID for the name field in a normalized database.

umm, not true again. You CAN use single quotes but you can also use double quotes if you use Chr(34) OR use triple doubles (""") which I don't like.



The problems come if the name field has a single quote - like for O'Brien, etc. So, then using the Chr(34) doesn't have that issue. But if you use single quotes and the field has a single quote in the data it will then throw an error. So, you would either need to use my method or use the Replace function (which I find more confusing than simply using CHR(34))

 

[SOS]

since ideally, you would want to be filtering on an ID for the name field in a normalized database.

Yes, but if you had to look up the ID based on the name ...

 

[Datagopher]

That's true. I haven't come across that in awhile though. Typically, I'll have it setup where it's a drop-down for the name and they start typing in the name and it will bring them to that name and when they click, it brings them to the record but you're right, it would serve that purpose.

Yes, but if you had to look up the ID based on the name ...