Gossamer Forum
Home : Products : DBMan : Discussions :

Re: Last try: Select field also pulls related data

Quote Reply
Re: Last try: Select field also pulls related data In reply to
I have not seen what you are wanting to do done before. I have a feeling it would really slow down the function of your database if it had to look and compare several fields. It would be much quicker to just have people enter the city and country.

What might help is to include instructions within your html_record_form so people will know for instance not to use abbreviations. Show an example of how you want the name of the school field filled in (to prevent dups with different spellings).

For instance above the field for the school name include something like this:
"Please do not use abbreviations for your school name, each school name should be spelled out in full (i.e. St. Peters would be entered as Saint Peters)"

I have found if you provide instructions and examples users are likely to follow your examples and help to keep things consistent within the database.

You can also use the following:

Make every word in a field Upper Case

$rec{'FieldName'} =~ s/(\w+)/\u\L$1/g; ## change words to start in upper case

Place this at the beginning of html_record form, and html_record or html_record_long.

This would prevent the problem with having people enter in all lowercase and having the entries being duplicated due to the case.

Hope this helps a little

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
Subject Author Views Date
Thread Last try: Select field also pulls related data csky 3414 Feb 9, 2001, 2:23 PM
Thread Re: Last try: Select field also pulls related data
Karen 3331 Feb 9, 2001, 6:09 PM
Thread Re: Last try: Select field also pulls related data
csky 3347 Feb 9, 2001, 10:19 PM
Thread Re: Last try: Select field also pulls related data
Karen 3341 Feb 10, 2001, 1:16 AM
Thread Re: Last try: Select field also pulls related data
csky 3318 Feb 10, 2001, 10:28 AM
Thread Re: Last try: Select field also pulls related data
LoisC 3303 Feb 10, 2001, 11:04 AM
Post Re: Last try: Select field also pulls related data
csky 3310 Feb 10, 2001, 1:23 PM