|
DeathFox Member Posts: 57 From: Registered: 04-25-2006 |
How do I get a specific data from a table? (VB 2005) [This message has been edited by DeathFox (edited September 24, 2006).] |
kenman Member Posts: 518 From: Janesville WI Registered: 08-31-2006 |
What kind of table?? .xls, .db, sql |
|
DeathFox Member Posts: 57 From: Registered: 04-25-2006 |
I think SQL tables. |
HanClinto Administrator Posts: 1828 From: Indiana Registered: 10-11-2004 |
Is this from a windows forms table control, or from a database, or what? If you're a little more specific, I can probably give you a nudge in the right direction, but it's a little vague at the moment. --clint |
|
DeathFox Member Posts: 57 From: Registered: 04-25-2006 |
I have a CUSTOMER table, and it has a ID#,FName,LName,Account# and an ACCOUNT table with Account#, Balance, CustomerID# and both ID and Account# are foreign keys in both tables. Now I need to automatically create an account everytime I create a customer. But I cant since it will check if the foriegn key exists or not in the account table, and since the account table is still empty then it will also affect the creation of the customer tables so in short, it will result in no tables being made at all. So I made it so that I first will create a customer with only a automatically generated ID, first name and last name. Then I would get the value of the automatically generated ID number, and create a new account with an automatically generated account, balance and the value of the Customer ID from the CUSTOMER table. And will do this the same with the Customer table in which i will insert the generated Account# into the customer table. Now my problem is how to retrieve the data from the table. Plz help |