Hi! Due to some constraints, my database is configured a bit differently. With reference to the image below, I want to understand if it is somehow possible to define a random field here: Rather than saying field 54, can I have field X (where the value of X changes in the List of Items)
Here is how my data is shaped:
My app has a list of Items from table 1 and shows Details 1 & 2 of that item. Along with that, I want it to display another value from Row 1 of Table 2, where the field is selected on the basis of Original Item ID. For example, in case of ItemID 1, I want the data point “ItemID=1 Qty” of Order table, and for ItemID 2, I want the data point “ItemID=2 Qty” of Order table.
Thanks in advance. My database configuration has its constraints and I can’t (sadly) change that. Thus, looking for such hacks