Hi everybody,
I have a list page in which i have records and a "Info" button that dynamically select
the current record using the GetCurrentRecord() function.
Thes structure is basically as follows:
Field1 Field2 Field3
(Button_Info) data1 data2 data3
(Button_Info) data4 data5 data6
(Button_Info) data7 data8 data9
(Button_Info) data10 data11 data12
As for now, when user clicks on the Button_Info, an email is sent to a predefined mail address and
everything works ok, now i'd like to go a little further.
In the Table (Microsoft Access db) that stores the User Names and Password, i have added a "email_to" field in which
are stored mail recipients to which tha mail should dinamically be sent.
So if User A logs in and has "email_to" set to xyz@example.com, clicking the info button on row 2, xyz@example.com receives data4, data5, and data 6.
So if User B logs in and has "email_to" set to abc@example.com, clicking the info button on row 4, abc@example.com receives data10, data11, and data 12.
Is this accomplishable using $_Session variables. I have noticed that these variables pertain mainly to the login Windows, but i cannot figure out how to retrieve
data from the "email_to" of the current logged in user value and pass it to runner_mail procedure.
I would also like to know how to create a windows that pops up when User press some of the above buttons, with some field data gathered from the source table and with
some data (i.e. free text in a memo box) that the user can fill and send an email instead of saving the record (data are retrieved from external source via MS Access database
and are read only).
Thanks in advance for any suggestion that may help.
Roberto
