1

(13 replies, posted in Database applications)

ehwagner wrote:

denzkie1191,
Attached is another option. As you can see, MVD is very flexible in doing things in various ways. Not one is really any better than the other.

thank you for helping me sir..

2

(13 replies, posted in Database applications)

sibprogsistem wrote:
denzkie1191 wrote:

hello sir, i got the sample that you've made, can you pls. explain what is happening in your sample?
sorry sir i'm new to this application, i noticed u used script, but too bad for me sir i don't know how to code yet in this platform.
thank you for your effort sir.. i appreciated it.

 

this script checks if such a name exists in the database, if it does not exist, then adds it, and if it exists, a new record is associated with it

ow i see, thank you sir..

3

(13 replies, posted in Database applications)

derek wrote:

Hi Denzkie, Sibprogsistem,
I don't think it's possible to check for duplicate entries without writing a script.  However, it needn't be complicated. 
Please see the attached as a simple duplicate check (there are other ways but they involve more lines of code);  there is a more detailed explanation in the script comments.
Shout out if anything's not clear and I'm sure someone will try and lend a hand.
Derek.

thank you sir..

4

(13 replies, posted in Database applications)

sibprogsistem wrote:
denzkie1191 wrote:

Just wanna ask if there's a way to prevent duplication of entry?

i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..


if you need to optimize the database

hello sir, i got the sample that you've made, can you pls. explain what is happening in your sample?
sorry sir i'm new to this application, i noticed u used script, but too bad for me sir i don't know how to code yet in this platform.
thank you for your effort sir.. i appreciated it.

5

(13 replies, posted in Database applications)

Just wanna ask if there's a way to prevent duplication of entry?

i'm making a data entry system and i noticed that if you enter a same data it will duplicate, pls see my screenshot..