Search options (Page 1 of 6)

thanks tcoton
My project was incomplete so I had to use a sample.
here is the realistic data you asked for
and " NO " you didn't understand what I meant
I have recorded 2 instances in the attached project.
what I want is:

1) the last column in the  first line of the TableGrid1 in the Searchform  should be 20 Pine, 30 Oak
but as you can see it only shows 20, 30

2) and after the last column I need another column that shows 50 ( sum of 20 + 30 )

Am I now clear enough?

Thanks for the reply
I know that I can choose not to use cascade.
I have attached a sample.
suppose you record something wrong in a (combobox1 Mainform) and you want to delete it while keeping other data.
If I don't use cascade delete then I get an error
If I use cascade delete all the data are lost.
What I need to do is that when I delete the data in (Tablegrid1 Bank) other data that are recorded should be intact and only the data of (combobox1 Mainform) should be cleared.
Do you think it can be done using a script?
thanks a lot

Hi Derek
I was looking for duplicate script and came across your sample " test1a option.zip "
Its exactly what I needed for my project but with a slight modification.
What I need is that the messagebox ('Duplicate Record Found) is shown but let me choose to insert a duplicate record or not
In my project sometimes I need to add duplicate records .
Please tell me how to do this
thanks

Hi
the project that Vladimir have attached  is also what I needed.
A couple of quick questions :

1- What is the registry code and how can I find or change it?

2- Is the registry code fixed or can it be random based on each computer?

thanks a lot for the great help

lots of thanks Derek for the great tip
it helped me a lot with my project

thanks sparrow and k245
I explained my problem incorrectly.
in the sample that I have attached we have 2 different users with 2 different passwords.
What I'm trying to do is to change password for each user using Button1 frmMain and obviously  the password should be depended on the selected user. I should be able to set different passwords for different users
this sample is not  role-based

username: Admin     Password: admin
username: User        Password: user

Hi
I have posted this topic a long time ago.
" K245 " inserted a button in the MainForm to change the password.
in the role-based you can change the password from the toolbar.
is it possible that in this sample which is not a role-based access control, the change password is shown on the toolbar?
there is also another problem:
there are two users in this sample , when I change password for one user, the other user's password is also changed

Hi guys
I'd like to add another line of data to this project when it shows a person's birthday.
What I need to do is that  in the form "frmBDayList" the department of that person should also be shown.
like this:
First name   -  Last name   -    age   -  department