Forum Discussion

Raymond1983's avatar
Raymond1983
Regular Visitor
6 years ago

Data dissapears in matrix

Hi,   I looked around on the internet for a couple of hours but can't find a solution.    I have got some tables wich is my information. The lookup tables. This is information about projectnumber...
Need Help
FarhanAhmed's avatar
FarhanAhmed
Community Champion
6 years ago

Right Click on the Bill Number in Matrix Visual Field List and Click "Show Items with No Data" and see if this solves your problem.

Raymond1983's avatar
Raymond1983
Regular Visitor
6 years ago

Hi, thanks for the reply

 

It doesnt help since he then shows under the projectnumber every single quotation number that is in the lookup table, and under the quotation number every single bill that is in the data table. So that ends up with a big big list of empty unnecassery rows with numbers for every projectnumber.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Raymond1983 

    Do you check if you have correct relationships among tables and the "aggregation" of columns?

    If this problem still occurs and is related to designing, you could share some simple example so we can make a test.

     

    Best Regards

    Maggie