select where statement.
I have two tables, MANUFACTURER and INVENTORY (1:N)
In the Inventory table I select the Manufacturer - so far so good.
I have added a view which I want to use to display all other inventory items that match the selected manufacturer.
how do I filter the view to only show records that match the Manufacturer.
4 replies
-
No need to filter. As you say select INVENTORY will show all your inventory. If you use the relationships you have created you can join them together, so don't use select but go to the manufacturer and then to the inventory belonging to it with this simple formula.
MANUFACTURER.INVENTORYRegards John
-
That's what I thought but I get this error. Data model:
Where am I going wrong?
-
-
Got it! The issue comes in where the Link is named something different to the table it refers to if you know what I mean
-
Only INVENTORY needed
Content aside
- Status Answered
- 6 mths agoLast active
- 4Replies
- 67Views
-
3
Following