access INSERT into table
Posted on 2013-01-23
Private Sub Command397_Click()
Dim i As Integer
For i = Me.clientOneMobile To Me.clientTwoMobile
CurrentDb.Execute "INSERT INTO files(fileID)VALUES(" & i & ")"
This is code which Inserts new records into Table called Files.
There is also a related table Clients.
Clients is the One and Files is the many.
How do I adapt the code to proi=vide new records for a specific Client, say, who has an ID of 5 (by way of unique index)
A WHERE addition to the code above?