Data Model

[rkpatelqlikview]

Hi, Can you please suggest how to build a good data model for attached application.

And i need to show Yes/No if the DO numbers of Trip Table available in Master Table then "YES" otherwise "NO".

Need count  no.of entries DO numbers in Trip from Master. and how to show the matched DO number?

Thanks in advance.

[Anil_Babu_Samineni]

In your model, there is only one table but

And i need to show Yes/No if the DO numbers of Trip Table available in Master Table then "YES" otherwise "NO".

[rkpatelqlikview]

Hi Anil,

Thanks for your quick response.

sorry. This is my application.

Can you please suggest how to build a good data model for attached application.

And i need to show Yes/No if the DO numbers of Trip Table available in Master Table then "YES" otherwise "NO".

Need count  no.of entries DO numbers in Trip from Master. and how to show the matched DO number?

Thanks in advance.