Prevent duplicate records from repeatable groups

[stephensaid]

Hi,

I have two tables:
Customers

group 1​

id​

code​

name​

group 2 (repeatable)​

product (linked to Products - id)​

discount​

notes​

Products

id​

code​

desc​

​

I want to prevent the user from entering a product under the same customer twice. As it is, the user can enter it infinite times.

Any suggestions.

I also tried having a separate table for discounts which may be a better model, but for simplicity's sake I am trying this out first a will most probably re-model later on.

Regards
Stephen

 

[troester]

There's "areuniquevalues" validation.

 

[stephensaid]

Hi

Installed the areuniquevalues validation plugin and when I select it on the element I receive the following:

Strict Standards: Declaration of PlgFabrik_ValidationruleAreUniqueValues::validate() should be compatible with that of PlgFabrik_Validationrule::validate() in/home/bdlbooks/public_html/projects/plugins/fabrik_validationrule/areuniquevalues/areuniquevalues.php on line 27

Strict Standards: Declaration of PlgFabrik_ValidationruleAreUniqueValues::getLabel() should be compatible with that of PlgFabrik_Validationrule::getLabel() in/home/bdlbooks/public_html/projects/plugins/fabrik_validationrule/areuniquevalues/areuniquevalues.php on line 27

I am using Joomla 3.4.1 and Fabrik 3.3.2.

Regards
Stephen

 

[troester]

Pure download version or GitHub update?

 

[stephensaid]

Downlaod version. I am in the process of updating from GitHub right now. Should I continue?

 

[stephensaid]

Joomla prompted me with an update for the plugin. After running it, the error went away.
[edit] still running Download version, not GitHub [/edit]

I am now trying it out but it lets me cerate duplicate records.

Can try it out here:
http://www.bdlbooks.com/projects/index.php