ladyhas.blogg.se

PhpMaker cannot handle parameterized Views so I am asking for a way to get the Year variable into the form. Year is an external value NOT in the products table that I need to input from a dropdown combobox to calculate against the existing fields (startyear and endyear) and then use that result to further filter the recordset.

This will cause everytime your user open the 'Master/Detail Add' or 'Master/Detail Edit' page, then the value of 'CustID' field in 'assignment' table will automatically be linked and auto-filled-in in the 'assigmentdetails' table. The filtered recordset at this point is showing all records with the currently selected Manufacturer and ProductID From your 'Master/Detail' setup in PHPMaker, drag and drop field 'CustID' from 'assignment' table into 'CustID' field in 'assignmentdetails'. Select manufacturer, productID, descrip, startyear, endyear from products where BETWEEN Coalesce(products.startyear, AND Coalesce(products.endyear, productID are both existing fields in the products table and I select them first from dropdown comboboxes on the phpmaker form. The result set is derived by entering a single year and then using the coalesce function on the staryear and endyear to determine if the record fits the criteria. There IS NO Year field in my table, only a startyear and an end year field