Quote:What I am trying to do is when somebody enters the account number field in my notes database, I want it to display a box with all of the account numbers and customer names. Is this possible?? I was thinking with @popupmenu , but I cannot figure out how to program it.
Yes, you can certainly do that. This can be accomplished either using @popupmenu or xuserselectr command. I believe you will be a lot better off using xuserselectr command than @popupmenu, especially if you have a lot of customers. xuserselectr narrow down your customer list just using a couple of letters of your customer name.
Logic and purpose for use of @popupmenu along with @xlistvalue and xuserselect is the same. It provides you with the list of all values from selected element of an application for you to select. xuserselectr command will give you a narrowed down list.
If you want to have customer name and account# both listed, you might have to make one more element in the database you are getting this list from, combining,
CustomerLastName +", " + CustomerFirstName + ", " + AccountNumber
This way you will be able to look for customer using last name and confirming that with FirstName.
This topic has been discussed in details under following links.
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...After going through these, if you still have any question or problem, please do not hesitate to post here. This forum is all about helping each other.