I'm new to model-driven apps and have searched everywhere for the issue that I'm facing. I have the following Dataverse tables:
Table 1 - Main Database with the following columns:
SR ID - primary column - retrieved from SR Power BI dataset via a Power Automate flow
Asset Type - retrieved from SR Power BI dataset via a Power Automate flow
Sub-Type - dependent on Asset Type selection - needs to be dropdown from AT ST lookup table
K Ref No - drop-down from K table
Table 2 - Work Log:
Work Log ID - retrieved from Work Log Power BI dataset via a Power Automate flow
SR ID - retrieved from Work Log Power BI dataset via a Power Automate flow
Incident Date - retrieved from Work Log Power BI dataset via a Power Automate flow
Table 3 - K Table:
K Ref No
K Incident Date
K Minutes
Table 4 - AT ST Lookup table
Asset Type
Sub-Type
In Table 1:
- Sub-Type is dependent on the pre-populated Asset Type and the list for the dropdown comes from the AT ST Lookup table
- K Ref No will be allocated based on the K Table
In Table 2 - should be able to have a form/view/grid where I can show the necessary Work Logs alongside the corresponding SR ID.
In Table 3 - should be able to have a form/view/grid where I can show the necessary K Table columns alongside the allocated SR ID.
I made Sub-Type in Table 1 a lookup column to Sub-Type in AT ST Lookup table with Sub-Type being the Primary Column in AT ST Lookup table, however, it's a many-many relationship since in AT ST Lookup table can have the same Sub-Type appear for different Asset Types.
My question is... what do I do? How do I accomplish the above?
I hope I'm clear in my question/query, if not then please let me know if you have any further questions.
15
Share
Report
All responses (
Answers (
