Delete Query Question

[Bill6868]

I can’t believe I’m having trouble writing this delete query:

I have a table named [tblTeamMembers]; I want to delete all member’s records in this table that belong to a particular team. I created a table [tblVariable] which I populate with the name of the team. In the delete query I show both tables but I’m not having any luck with the “Where” condition. I have drawn no relationship between the two tables as I don’t think I should have to.

I want to delete all the records in the [tblTeamMembers]where the variable field [team name] in my [tblVariable] = the [team name] in my team members table.

Any help, suggestion would be greatly appreciated.

Good grief!

 

[Bill6868]

I think I answered my own question. Fields in both tables must be indexed and the relationship line must be established between the two tables.