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 ?

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 ?