• isabella anna
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi,

I have created an Object called Daily Diet. It holds the information of daily diet of a patient. It has following fields:

Patient - Master
Date - Date
Diet -Lookup
Food Item - Lookup
Consumed Quantity - Decimal

Eg: Mark - 12.10.2008 - Breakfast - Biscuit - 5  => Daily Diet ID 1 (Name Field)
      Mark - 12.10.2008 - Breakfast - Tea - 1 => Daily Diet ID 2

Currently, if I add new record with the same values, it will be simply added
    Mark - 12.10.2008 - Breakfast - Biscuit - 6 => Daily Diet ID 3

Similarly, if I change Tea to Biscuit in record 2, it will be like 
Mark - 12.10.2008 - Breakfast - Biscit- 1=> Daily Diet ID 2

So, I have three records with same data. How can I prevent it ?
  • October 28, 2008
  • Like
  • 0