I have a few older applications which I have, successfully, using for many years and that contain programming for @XLU's. These were accomplished, with many thanks, with the help from Lantica members. I hav had to create a new application and am at wit's end trying to utilize the @XLU.
It is an Alumni application. It has two databases(?) One is simply called Alumni and contains the Alum's info. The other database(?) is called Statement. If an Alum signs up for our gala reunion I would like their info to go into the Statement's form. I have been able to get to the point where upon opening the Statement database I can choose which Alum to add but CAN'T get his relevant information to be copied into the Statement.
I have used the programming similarily used in my other Applications but to no avail.
Help would be appreciated.
Peter

Hi Ray,
Here is the coding I have. I have tried a slightly different coding for last and first names and then the rest of the contact info. I'm sure I probably have it pretty much screwed up. Please remember that I am still a novice at progrmming so please spell everything out in any coding you prepare.
Thanks,
Peter


If @add then
Last Name:=@XLU(@FN,Alum0,"Alumni!Alum","Last name")
First Name:=@XLU(@FN,Alum0,"Alumni!Alum","First Name")
Address:=@XLU(@Fn,Alum0,"Alumni!Alum","Address")
City:=@XLU(@Fn,Alum0,"Alumni!Alum","City")
State:=@XLU(@Fn,Alum0,"Alumni!Alum","State")
Zip:=@XLU(@Fn,Alum0,"Alumni!Alum","Zip")
Home Phone:=@XLU(@Fn,Alum0,"Alumni!Alum","Home Phone")
Cell Phone:=@XLU(@Fn,Alum0,"Alumni!Alum","Cell Phone")
Email:=@XLU(@Fn,Alum0,"Alumni!Alum","Email Address")

Hi Peter,

The element on the Alumni form that you are wanting to match to is named Alum: (Note the colon) so your code was almost there. The following should work for you.

If @add then
Last Name:=@XLU(@FN,Alum0,"Alumni!Alum:","Last name")
First Name:=@XLU(@FN,Alum0,"Alumni!Alum:","First Name")
Address:=@XLU(@Fn,Alum0,"Alumni!Alum:","Address")
City:=@XLU(@Fn,Alum0,"Alumni!Alum:","City")
State:=@XLU(@Fn,Alum0,"Alumni!Alum:","State")
Zip:=@XLU(@Fn,Alum0,"Alumni!Alum:","Zip")
Home Phone:=@XLU(@Fn,Alum0,"Alumni!Alum:","Home Phone")
Cell Phone:=@XLU(@Fn,Alum0,"Alumni!Alum:","Cell Phone")
Email:=@XLU(@Fn,Alum0,"Alumni!Alum:","Email Address")  

-Ray

Hi Ray.
Found the solution to the Email not copying
In the coding below:
Email:=@XLU(@Fn,Alum0,"Alumni!Alum","Email Address")

it should have read:
Email:=@XLU(@Fn,Alum0,"Alumni!Alum","Email")

I deleted the word Address .

But I still have the issue with it not working in the Sesame Program only in my shortcut.

Thanks,
Peter

Hi Ray,
On my desktop I created a shortcut to the Alumni.db. That is the application that works. If I open Sesame and scroll to the Alumni.db file it will not utilize the coding for the statement you helped me with. When I add a new Statement the pop up list of Alum does not show and just takes me into the statement file. However, if I type two or three letters of an existing alum, followed by two .. it fills in the fields.
Weird!!

Hi Ray,
Sorry to be such a pain. I got frustrated and deleted the application and started from scratch. I can still not get the Statement database to where upon opening it I can choose which Alum to add. I will send the files to lantica support.

Thanks again,
Peter