Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationship

Hi,

 

there are two tables visit, stock count.  the scnario is we need the stock count quantity in visit table by comparing the customer and date. there might be more than 1 visit for a customer in a day.

customer->visit(one-many)

customer->stock count(one-many)

 

Thanks

 

Need Help

1 Reply

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

    Hi Anonymous ,

     

    Could your share some sample data or table structure?

    You can describe the results you expect in the form of an image or a table.