I have two tables within the same Base.Table A is a list of yarns and has a column Length which is the total length (integer) of yarn available for the yarn named in that row.Table B is a list of patterns and has a column Length of Pattern which is t...
This worked perfectly. Set the trigger up for any time the Length field was updated. It will mean updating all of the existing entries, but that won't take long and it will allow the list of usable patterns to adjust as the Length goes up and down.Th...
