|
I have to repeat for remeber my ask:
in my database application and in my form ,
I use 2 table from SQL .In table1(mainTable) my fields are id_car,car,id_city
and in Table2 my fields are id_city,city .
id_city in table1 has a relation to id_city in Table2 , but
I want to fill the Datagrid by table1 .I have a combobox for displaying the city by the the id_city from table2 (from the relation exist between two table )and ,I have a textbox for displaying the car and a datagrid contaning from city and car,in my form .
and for displaying the records , I use a View in SQL .
because when I want to save and repeat one city in the some or more record , I select it by the id_city from the table2 .
Now I want to add,update,Delete my database application
in spite of that we know about the relation table1 and table2 .
ofcourse my main table in the application is the table1 .
thanks in advance!!!
mostafa hosseiny b.
|
|
|
|