Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding records...nearly !

Status
Not open for further replies.
jerstep

jerstep

Technical User
Mar 22, 2002
18
0
0
AT
I have a SQL "music collection" DB. I have two tables Artist and Album.

I want to add records to this using VB. How do I do this ?

I can display the records using the Datagrid control. I've added a new record using this control, to the two tables which works fine but the records records are not linked i.e. the artistid field in the albums table contains a null.

anyone, any ideas ?

obviously, i'm new to this, so be patient.

thanks.
j.
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
129
strongm
strongm
MAVTCR
  • Locked
  • Question
Adding help files
Replies
16
Views
131
strongm
strongm
sal21
  • Locked
  • Question
fill array from recordset
Replies
6
Views
124
2009luca
2009luca
Franka71
  • Locked
  • Question
Connecting to a Disconnected Recordset...
Replies
1
Views
65
Andrzejek
Andrzejek
kskinne
  • Locked
  • Question
help with code used to update multiple records from datagrid 1
2
Replies
33
Views
293
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top