Having problems getting a single category embedded view to work!
I have two forms from two different db’s. Form “Equipment” and Form “Customer”. Form “Customer” contains a field called “ID” which contains the customers ID. Form Equipment contains a field called “CusID” which is the id for that customer.
I created a view with the first column sorted and categories with the “CusID” in the Equip db.
I then embedded this view into the customer form.
It is currently showing all equipment for every customer? How can i get it to show only the equipment with the matching customer ID?
Where CusID from Form equipment = ID from Form Customer
I tried putting in ID into the single category but that showed nothing?