Skip to content

Query: SubQry Product Principal Reports Structure NOT Included

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

Tables Referenced

  • Product Principal Reports Structure
  • Product

Columns Selected

  • [Product Principal Reports Structure].[Product Principal Reports Structure ID]
  • [Product Principal Reports Structure].[Product ID]
  • [Product Principal Reports Structure].[Principal Reports Structure ID]
  • [Product Principal Reports Structure].[nPrincipal Reports Structure ID]

Where Clause

((([Product Principal Reports Structure].[Product ID])=[Forms]![Frm Add and Edit

SQL

SELECT [Product Principal Reports Structure].[Product Principal Reports Structure ID], [Product Principal Reports Structure].[Product ID], [Product Principal Reports Structure].[Principal Reports Structure ID], [Product Principal Reports Structure].[nPrincipal Reports Structure ID] FROM [Product Principal Reports Structure] WHERE ((([Product Principal Reports Structure].[Product ID])=[Forms]![Frm Add and Edit