FiveTech Support Forums

If a customer have the same surname and different name how I must create the search ?

I made the index
INDEX ON Upper(Cust->first)+upper(cust->last) tag Firstlast

cCognome:= cust-first
cNome:=cust->last

@ 26, 10 SAY "Cognome :" OF oDlg SIZE 34, 8 PIXEL FONT oFont
@ 24, 46 GET aGet[2] var cCognome    OF oDlg SIZE 80, 12 PIXEL FONT oFont UPDATE

@ 26, 127 SAY "Nome :" OF oDlg SIZE 34, 8 PIXEL FONT oFont
@ 24, 146 GET cNome OF oDlg SIZE 100, 12 PIXEL PICTURE "@!" FONT oFont UPDATE

if I seach dbseek(cCognome+cNome) not run ok

any solution pls

Silvio,
remove space between the names.
Regards,
Otto

I try also with alltrim not run

If I seach dbseek(cCognome+cNome) not run ok.

yes of course but -i remember I had on clipper+fw ( perhaps listbox) a possibility when I presses a Letter ok keyboard it showed me all customers initiating with that Letter.

my problem is another: I have two types of customers ..
1 reservation holder: the one who rented the umbrella
2. guests who are placed in each umbrella because they can be up to 4 (3 + 1reservation holder) for the normal umbrella and 10 (9 +reservation 1 holder) for hawayano type umbrellas.

in the archive I have inserted in addition to the surname and name of the owner of the booking also other 9 character fields (cr 30) where the end user can insert the names of the guests relative to that customer

the search must be done first on the booking archive, once a correspondence has been found with the name and surname of the customer who made the booking, the name must be searched for in the customer archive and selecting that record ie the name and surname found must be done a search in the 9 character fields to search for the name to be searched

or if I have to look for a guest not knowing in which umbrella is located I have to do a search on the customer archive to compare the name to be searched also in the 9 fields and then if I can trace the owner of the reservation I can see in which umbrella the guest was added

or do you have the best solutions?

Now I understood I cannot make it with tdatabase( or tdata) and I have problem if i cannot use numcli

Now I wish change the Numcli from strzero(Recno()+1) to 13 Cr

I actually use 3 fields: First, last, and company names.

If the customer is not affiliated with a company, then I put their name, ( Last + First, NOT trimmed ... leave the spacing in place ) into the company field. I use the index on the Company field for searches and ordering in the xbrowse. It NEVER fails.

Tim,
I cannot believe you not use a code number for a customer ...on invoice you use only First name ?

and then on Beach application I have a special feature

I must search a guest /customer

if is a guest and is on a umbrella or Palm or tent

each customer can save until 10 people or family members

If I search " Tim Stone" the procedure must be able to show me which umbrella is the guest or the customer..

imagine having 2500 umbrellas for beach and many establishments have at least 3 beaches (zones)

Silvio,

Each customer does have an account number. I store a lot more information on them also. My xBrowse actually allows me to look them up by account number, company ( or Last-First name ), phone number, or even email. By clicking on the header, I select the field I want to search in, it resets the list in that order and I start typing in the info.

Thus, to do a search I popup the browse, click on the company field ( remember, last name + firstname or the actual name of a company ), and start typing the first few letters. The browse moves to that position instantly.

For efficiency, if I was linking people to umbrellas, I would use their account number, but I don't have to even show that link because people don't know the numbers. They know their name.

For what you want to do, each umbrella would have an assigned ID. A record would be created for a date, that umbrella, and have the renter's account number in one field, and the occupants account numbers in other fields set aside for them. I'd link the files, and the display could show the names.

Of course here we only track who rents something, not who might sit under it.

>Each customer does have an account number.

Well, how to create this account number?
I've always done a 4-digit number by taking it from the record number.
The end user wants to see the account number in the insert / edit dialog.
According to James and others with tdatabase (or tdata) this is not possible because on the net it could change if someone else enters the same account number because it is taken from the record number