Query: SubQry Products NOT in Proposal

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

• Proposal Products
• Proposal

Columns Selected

• [Proposal Products].[Proposal ID]
• [Proposal Products].[Product ID]

Where Clause

((([Proposal Products].[Proposal ID])=[Forms]![Frm Add and Edit Proposal Product

SQL

SELECT [Proposal Products].[Proposal ID], [Proposal Products].[Product ID] FROM [Proposal Products] WHERE ((([Proposal Products].[Proposal ID])=[Forms]![Frm Add and Edit Proposal Product