Topic: How to solve this issue ?

welcome everybody,

is there a way to solve the attached issue?

I prefer no-code solution if it is possible.

Thanks

2 (edited by derek 2020-04-28 17:19:39)

Re: How to solve this issue ?

Hi,
Looking at your screenshot, it's a bit unusual to have similar entities (Unit1, Unit2 and Unit3) all part of the same record rather than 3 discrete records and I would guess this is the cause of your issue, but it's a simple enough fix. 
Can you attach your project (zip up everything except the .exe).
Then someone will be able to take a look and suggest fixes or alternative approaches.
Regards,
Derek.

Re: How to solve this issue ?

derek wrote:

Hi,
Looking at your screenshot, it's a bit unusual to have similar entities (Unit1, Unit2 and Unit3) all part of the same record rather than 3 discrete records and I would guess this is the cause of your issue, but it's a simple enough fix. 
Can you attach your project (zip up everything except the .exe).
Then someone will be able to take a look and suggest fixes or alternative approaches.
Regards,
Derek.


Thank you derek,

The project is attached.

Post's attachments

Attachment icon Items_.rar 294.41 kb, 204 downloads since 2020-04-30 

4 (edited by derek 2020-04-30 23:33:20)

Re: How to solve this issue ?

Hi,
The problem you have is because you have 4 relationships between the 'items' and the 'units' tables.  MVD will only automatically retrieve the unit_name for the first of the relationships.  For the other 3 relationships (the sales units), you have to do this manually.  This is done by adding calculated fields in the database tables.  Have a look at the attachment (Items_Option1) for an idea how this is done.
As I mentioned previously, it's a bit unusual to have similar entities (the 3 repeats of sales items) on the same record.  To see a different approach, have a look at the attachment (Items_Option2).
Neither approach is 'right' or 'wrong' - it's more a matter of 'horses for courses' and underlines the flexibility of MVD.
Regards,
Derek.

Post's attachments

Attachment icon Items.zip 677.83 kb, 271 downloads since 2020-05-01 

Re: How to solve this issue ?

Excellent approach especially  the option 2 .

Thank you derek for your help.