P
pete johnson
i have two tables, faxprotol and tblbadfaxes. i want to delete all records
in faxprotocol which have a record in tblbadfaxes. of course each table
has a field named faxnumber and i have set a relationship between them.
faxprotocol has many records and tblbadfaxes has unique records (by
faxnumber).
i dragged the asterisk from the "many" table to the grid and in the delete
row i typed [faxprotocol], so it reads "from [faxprotocol]". without the
quotes, of course.
i dragged the field faxnumber from the tblbadfaxes to the grid and typed
[tblbadfaxes]![faxnumber]=[faxprotocol]![faxumber] as the criteria.
i get an error of "the text you entered isn't an item in the list.
where did i go wrong?
pete
[tblbadfaxes]![faxnumber]=[faxprotocol]![faxumber]
in faxprotocol which have a record in tblbadfaxes. of course each table
has a field named faxnumber and i have set a relationship between them.
faxprotocol has many records and tblbadfaxes has unique records (by
faxnumber).
i dragged the asterisk from the "many" table to the grid and in the delete
row i typed [faxprotocol], so it reads "from [faxprotocol]". without the
quotes, of course.
i dragged the field faxnumber from the tblbadfaxes to the grid and typed
[tblbadfaxes]![faxnumber]=[faxprotocol]![faxumber] as the criteria.
i get an error of "the text you entered isn't an item in the list.
where did i go wrong?
pete
[tblbadfaxes]![faxnumber]=[faxprotocol]![faxumber]