General Development

I desperately need your help (VB related) – DeathFox

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