Hi.
I am wondering if this is possible or if we need to find another way of doing this. First a little background info about our setup.
We have 3 tables.
- Item Master
- Pricelists
- RMA Table
Item Master contains basic data on all Products in our Organization.
Pricelists contains Pricing information for all Products in our Organization.
We have a Lookup Column between Pricelists and Item Master to be able to expand the related data from Item Master when referencing the Table without having to reference the Item Master table directly. See below for a quick overview of the setup.
We are now trying to utilize that same logic in a Model Driven App for the RMA Table with a Quick View Form containing data from the Pricelists table.
So basically something like the below.
Our end goal is to expand the Item Master Lookup column in the Quick View form from the Pricelists Table to show some of the Related data from the Item Master column, but we are struggling to find a way to do this.
My question is:
- Is this even possible for us to do?
- If not, what would be recommended instead? We have considered Column Mapping of additional Lookup Columns in the RMA Table into the Item Master table, but would much rather prefer to not go that route if possible.
222
Share
Report
All responses (
Answers (
