Share
Report
2HEllo ,
I have a 4 tables :
Product table (virtual table from SAP)
I have a 4 tables :
Product table (virtual table from SAP)
Contact table (standart table)
Contact-Product (Contains the contact and product information as I cannot create N:N relationship for virtual tables)
In another table called Item I have a lookup to Product , so it shows all the products,
I want to filter this lookup to show only the product the user have access to based on the Contact-product table
How I acheive that, I dont want to create relationship between Contact-product and Item , because the contact product it's not used in the SAP,
Contact-Product (Contains the contact and product information as I cannot create N:N relationship for virtual tables)
In another table called Item I have a lookup to Product , so it shows all the products,
I want to filter this lookup to show only the product the user have access to based on the Contact-product table
How I acheive that, I dont want to create relationship between Contact-product and Item , because the contact product it's not used in the SAP,
Categories:
I have the same question (0)
All responses (
Answers (
