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.
Last Visit: 31-Dec-99 19:00 Last Update: 20-Jan-17 21:00