Editing data in a grid with join tables -

Hello,
I'm trying to create a grid that I will be able to add and update in. My RecordSource is SQL query with JOIN tables and database is SQL 2000.
I need grid to have combo boxes or dropdown lists that users can select only one of the values that is already in that database field.
I've done this in Access using Datasheet form and it was simple. It is like continious form. Does VB6 have something like Datasheet or it needs to be created and how?
I've checked postings, but couldn't find something that fits my needs.
Thanks!

Editing data in a grid with join tables -
Hello, I'm trying to create a grid that I will be able to add and update in. My RecordSource is SQL query with JOIN tables and database is SQL 2000. I need grid to have combo boxes or dropdown lists that users can select only one of the values that is already in that database field

Joining tables and Updating -
I'm trying to join two tables from Access in a datagrid developed in VB 6.0. I can update on of the tables involved in the JOIN by clicking on the datagrid and editing it. However, I cannot edit the other table in the JOIN through the datagrid. IS there any way around this? Any hel

[2003] Join 2 tables! -
hey there! need to join 2 tables to been displayed on a datagrid the filling part is no problem the part that im getting stuck is in the sql query where the join has to be done. got table A and table B, the join that i want to do is to display all the info of both tables all the

how can I use data relationship or join tables -
I want join to tables from an index field then I want to collecting field form both tables. Also, I want to place those field into a grid, in another words I want to place some field into text boxes and another fields into a grid. How can I do that. here is an example of my code. F

[2005] Proper Control for Editing data -
In VB6 we used flexgrids - and had to roll our own techniques for editing the grid. What is the proper control for editing grid like data in .Net. Right now I'm displaying data in a ListView - can that be edited? Are there better choices? I'm on a pocket PC - but this is a gene

***RESOLVED***SQL Query - Join Multiple Tables -
I know how to join two tables.... but i was wondering if it possible to join several tables together, ie 2 or more tables. This is because i need data from related tables in a single recordset so i can put the relevant info on a form, keep it in sync. I have tried but i get a 'Sy

Populate a Grid from a JOIN Tables -
Anybody know how to populate a grid from a JOIN tables database. If you have an example please let me know because I do not know how to start. Thanks

Mixing of JOIN and others -
i have a a few tables that need to be joined from a 'central' table. i use in-line sql: select a,b,c,d FROM central table JOIN a_T on... JOIN b_T on...and so on... However i have som

query and retrieve data from diff. tables -
Hello, The user supplies the name and the class and i need to show him all the data from 10 different tables matching the name and class. I try and find out the stdId matching the stdName and stdClass from tables studentPersonal and studentAcademic then when i have the stdId I join (o

My stupid data grid problem -
When i am editing the row for a grid(i.e. while entering values in the grid) i want to validate it. if i find value to be inapropriate i shall not accept it. hence give the user chance to enter valid data. can u explain this with sample piece of code? that would be helpful!! Also for

Query with join -
Hello, The user supplies the name and the class and i need to show him all the data from 10 different tables matching the name and class. I try and find out the stdId matching the stdName and stdClass from tables studentPersonal and studentAcademic then when i have the stdId I join al

Stupid data-grid problem! -
When i am editing the row for a grid(i.e. while entering values in the grid) i want to validate it. if i find value to be inapropriate i shall not accept it. hence give the user chance to enter valid data. can u explain this with sample piece of code? that would be helpful!! Also for

Update Multiple tables in datagridview -
Hello techz, I am developing a sqltool in which a query can be typed and executed and if any results, will show up in a datagridview ... Now if i execute a join query (suppose 3 tables) i need to update the grid and need to effect back in the database ... it need to automatically

Multiple Table Join -
I am currently trying to join all 4 tables together in one single sql statement. The tables are like A -> B -> C -> D having the key of D, sql statement should give a result of related records of D key. I;ve tried using statement below by i get some syntax error.

Editing & Saving from Flex Grid -
Hi ALL i have to enter data in a grid (i,e the grid must be editable). I have chosen FlexGrid for the same. Now, the changes the user makes on the grid must be saved to the access database, which I am unable to do ? I am using ADO to connect to the Database. Can anyone help me wi

Grids, editing data -
Hi all, I'm not that regular here but I was wondering if anyone can point me in the right direction as I'm sure I've missed something silly here. I want to display some data in a grid, the data is read from a file, then edited in the grid, then written back to the file however, I ca

Join Two Tables -
I haev two tables in Access 2000, with the same type of data in them. Table1 ID, Name, Company Table2 ID, Name, Company I would like to join this two tables in a query like this: Query1 Name, Company Is this posible? Tahnks

[2005] sql join & typed dataset -
I have a typed dataset generated by VS2005 for my sqlServer 2005 DB. All is great when using with queries & stored procedures (SP) that only work with one table. But I would like to include SP's that return data from many tables using inner joins. This is where the type dataset

data grid help -
hi to all i have a problem in working with datagrid. i got all values in grid from database now i want to add a new rcord in grid and also editing and updating a previous record but i got no way how can i do this tell me if there is any way to do this. thanks Hammad Umar

ado and multiple databases -
I'm trying to connect to several different data sources. It's possible to write a sql query to join tables in different databases, or even different servers for that matter. But an ado connection to sql specifies one database. How then would you join tables? With dbase you can spe

Data grid editing -
How to check how many times user has change or edit data grid values

dbgrid problem - Help! -
Hi, I have populated a dbgrid with data from a table in the access data base by binding the data grid to a datasource through code. When I run the form, the grid displays with a small button on the left most corner, with a + sign. When I click on the + sign, it shows me a link "

disable editing in datagrid -
I dont want to allow user to edit data grid for certain condition. right now my data grid editable but for one condition i dont want to allow any change in data grid how could it be possible. please help in this

[02/03] Join tables frm different connections -
Hi all, I have 2 tables frm 2 difference datasources. One in my access database and the other is an XLS file. I want to join these 2 tables based on a common field. How shall I go for it? Regards, Prakash

Editing & Saving data from the FlexGrid -
Hi ALL i have to enter data in a grid (i,e the grid must be editable). I have chosen FlexGrid for the same. Now, the changes the user makes on the grid must be saved to the access database, which I am unable to do ? I am using ADO to connect to the Database. Can anyone help me wi

join 2 tables or open a rs -
I have a big table with around 50 columns. I've to upload it to a SQL Server 6.5 and then write an asp page to search the records. Since SQL 6.5 has a limit on the length of a row, I've to vertically partition my table into 2. These two tables have exactly the same number of records a

Sorting base on Master Table -
HI, I have a dataset with two tables (order & productdesc) and one data relation. There is a grid showing the order table and also some columns from productdesc table. Everything works fine but I meet a problem on sorting. In the productdesc table, there is a sortingsequence

Share ideas on how your form looks like. -
Normally in a form I would split the form into 2 frames. tops is the view data using a grid and bottom are the combinations of textboxes, checkboxes and other necessary controls. Whenever user click at the record on the top(grid), I will populate the data on the frame below. Any editin

Editing a Grid Cell -
Hi, I trying to create functionality in a grid where I can actually enter text into a cell of a grid manually without entering text somewhere else and then loading the data into the grid cell. Any help would be greatly appreciated. Thanks, Jeff

Grid without datasources -
Hi all! Is it possible to use the datagrid (or some other net grid) without any database connected to it. I need just a grid for editing some cells, something similar to the grid of the property window. Can someone help me? Thank you!

VB.Net 2005 - Editing in a ComboBox within Grid -
I have a grid that has one of the columns defined as a ComboBox. My problem is that I can't enter data in the ComboBox. I'm sure I've missed setting a specific property but don't know which one. Any ideas? My grid is editable because I can enter data in other cells. Thanks,

Hiding columns within a Data Grid -
Does anyone know how to hide columns within a Data Grid? I have a Data Grid who's DataMember is a Relationship between two tables in a Dataset. I have some fields on the Grid that I'd like to hide. How would I do this. I read something about DataGridTableStyles, but couldn't get it

Need help on data grid's item editing -
Please tell me how can i make a data grid accept the changes made on a particular item on the click event of the data grid?

Data Grids -
Hi Everyone, I currently have a need for a Data Grid that I am populating in code where once I have finished populating the grid the user needs to be able to simple editing. Then once finished I can update the database. In order to do this I also need to lock the user out of some

combine tables (resolved) -
is it possible to join 3 tables in this manner: T1 - has 1 pk - x1 T2 - has no pk but 2 fk x1 and x2 T3 - has 1 pk - x1 basically i want to extract x2 something like: Select x2 from T1 JOIN T2 on T1.x1 = T2.x1 ..and ... it must be " from T1 JOIN....." thank you

Updateable data grid -
I'm building a VB application for our church which enables me to enter volunteer hours into the database. I have a data view on one table which is the source of a datagrid on my form. The data view contains the entry ID (which is the primary key) and family ID (which is not unique)

Odd Happenings with Views -
I'm using SQL Server 7.0 and I have a view in my database that obviously combines multiple tables. The Main table has alot of Foreign keys and in the view I'm basically just joining all the tables so I just can call the view instead of joining multiple tables everytime I want to get i

i don't use relation in my tables is it right -
peace be upon you i don't use relation in my tables but when i want to take data from my tables i use a join sql statment to do this is that right or not ??? - tell this time i don't have any information about how to make the Structure of my databse ( i made it depend on what i

sql and vb data grid -
what i have is a form which has a few text boxes and a data grid. i am using sql as the back end. i have created two ado data controls one for the data grid and other for the boxes. what i am trying to do is add data from both the text boxes and data grid into a single table. the probl