need your helps Very Urgent! please

i didn't undrestand how till now if you explain to me with the cods i may undrestand better!!!
and also how i can limit that in the databse??

I didn't undrestand your meaning : do i have to do againe the relation ship or the tables!!! caus ei don't have 3 tables i have only 2 tables!!!

1- for AUH_HOUSE Containes:
HOUSE_ID + OWNER_ID + OWNER NAME : Primarey key is House ID and the forighn key is Owner_ID

2- OWNER_SHIP contains:

Owner ID + OWNER Name : Primery key is Owner ID

and i made the relationship using the Owner ID (is that wrong) and the relation was 1:N

i only want to limit that if some body bought a new house but he already have 2 houses then it can't be entered to the system and gives an error or msgbox what ever!!

and the person will edit or enter new fields using VB6 Application where i used ADODC + Datagrid so if a person will enter a owner ID which already is there for 2 times then it gives a msgbox 'can't enterd , already have 2 houses"

SO how i will specify that ??

Do you mean that you want to limit that 1 person only can have max 2 houses from your application ?
So, when you try to enter the third house, it will return an error ?
Please advise me if i interpret it wrongly. Thx

Regards

It has been a long time since the last time i use VB. So, i am sorry if i could not give you accurate information. Other user please advise..
Actually, from one of your other post, you can get the answer already. I think ShafaqatAli has told you how to count the record, rite ?
Just use the similar method

Select Count(*) from AUH_HOUSE Where Owner = "The Name"

execute the sql, and then use a variable to catch the result.

If VARIABLE >1 then
Msgbox "Too many house already, why dont u give me 1 ?"
else
'Update the database
end if

Hope this can help, sorry for the lousy explanation. First time for me using forum.

Kind of hard to transfer a house with your method.