Database selection

Hi,
here are some tips:

1. proceed to the Visual Editor tab
   
2. turn on HTML mode, find this line:
   

   <!-- delete form -->
   

and add following code just before:

<A onclick="frmAdmin.a.value='update'; frmAdmin.submit(); return false;"

3. proceed to the Events tab and add BeforeDelete event.

Here is a sample code:

'Delete selected records

Hello Jane, thank you for helping me.
I have this setup of my tables:

this just a dummy database which i am learning on.
table:Waterfalls

ID: autonumber

WaterfalID: text( here I give a specific waterfall and ID (alphanumeric)

Waterfall name: text
etc.etc
then I have a logins table:
ID: autonumber

Login

Password

email

UserName
My question is
SHALL I also have a UserName field added to the Waterfall table?
If yes thei n the advanced security settings screen in the part which reads:
User can see and edit his own data only
What shall be the Maintable Owner ID field?
thank you.

Hi,
to use User can see and edit their own record only security method add new field where user login name will be stored to the Waterfalls table.

Then select this field and Login field as OwnerID on the Advanced security settings dialog on the Security tab.

Hi, Jane ,thanks again for helping
I think I am doing something wrong.please correct me:
table:Waterfalls

ID: autonumber

WaterfalID: text( here I give a specific waterfall and ID (alphanumeric)

Waterfall name: text

Login: text -----------added to the main table

------------------



table: logins

ID: autonumber

Login

Password

email

UserName
In the Advanced security Tab:
Users Table:OwnerID :

Login
MainTable:OwneID:

Login
checked the

User can see and edit their own record only
when I generate the project

I can see everybody's records, what I am doing wrong?

thank you

please check my setup at my website:
http://www.visualguideto.com/asprunner

I have just added a screenshot of the web outcome.

I also corrected/added to the MDB Description and Photogallery Tables additional fields Login and set the advanced security according to Janes's suggestion : to reach same outcome: Users still can records of other users.

I also uploaded the project to the demo account
http://demo.asprunner.net/xeops_hotmail_co...falls/login.asp

Hi,
your application works fine on the Demo Account server.

Please make sure that you copy all files to your webserver.

Hi, Jane thank you BUT WHAT IS interesting:)
here is my screenshot of the demo

account of my own application: the lines above , are they supposed to be seen???
also i see huge problem:
Once i logged in as Guest i was

able see your password you used to test my application.
also Jane, if possible how do I add in this cas and admin to see/edit all records???

Hi,
first make sure you have set up correct permissions for guest account on the User group permissions dialog on the Security tab.
Also I recommend you to send link to your pages to support@xlinesoft.com directly.

hi, Jane,
please help me to setup th logins table in the User group permissions diaog..
what i currently have is:
ID autonumber

Login

Pasword

email

Level
Level is important since it will differenciate admin from the rest of the user:

where admin will get 1

and the rest will get 2 as the value of level.
unfortunatelly I could understand how to DEAFULT all users as non admins, neither how to make sure that

application will by default add "2" to the list.
Or am i looking in the wrong direction???
thank you

hi, Jane, i have added level field to the logins table, and now are stumbled upon the user permisiions dialog.

my question is hwo to let application AUTOMATICALLY assign to everyone NON ADMIN rigths?

Hi,
just create admin group and default group for other users on the User group permissions dialog on the Visual Editor tab.