add records to INNER JOIN query

  • Thread starter Thread starter Co
  • Start date Start date
C

Co

HI ALL,

I use following query:

"SELECT Abonnementen.folder_naam, Abonnementen.gebruiker,
Abonnementen.folder" & _
"FROM Abonnementen INNER JOIN Kabinet ON
Abonnementen.folder_naam = Kabinet.foldername" & _
"WHERE gebruiker='" & sUserName & "'"

Now I want to add a new record to the table Abonnementen.

Abonnementen.Gebruiker = sUserName
Abonnementen.folder_naam = ListBox2.Items.Item(i)
but the field Abonnementen.folder = ?

Abonnementen.Gebruiker = textfield with UserName
Abonnementen.folder_naam = textfield with name of folder
Abonnementen.folder = numeric field corresponding to a certain
foldername

This is a numeric field in Kabinet named folder_naam. How do I get
this value?
Or is this not possible?


Marco
 
Create a form with the parent table. Then create on it a subform for the
child table. If joined properly, Access will populate the foriegn key field
in the child table with the primary key field data in the parent table.
 
Back
Top