Hi again!
My number is not generated by a function... in my insert, I don'T ask to add a value to this field..
See..
insert Password, Email into Members_Number values('value', 'value')
Memer_Number is a database generated number!
Why I split the database?
Because it's not because I need the Email then I need the Name and All the rest... When I'm looking for Email, I'm looking for the Number corresponding to this Email THEN use the number to manipulate datas... Make Email the key will be long sometimes to search trouhgt the table!
thanx again!
Pierre Paradis
Working for Technologies Softdesign inc.