AnsweredAssumed Answered

Field flagging another in different table

Question asked by chefportal on Sep 14, 2013
Latest reply on Sep 14, 2013 by BarbaraCooney

Hi All,


I know this is probably an easy problem, but have not been able to figure it out.


I have a 2 tables “products & suppliers” in the products table I have a preferred supplier field. And in suppliers table I have a preferred_flag field. My question is this, how do I choose a supplier in “Preferred Supplier” field and put a “1” in that supplier in the prefered_flag field in supplier table and un-mark the other suppliers that may have been marked (there should be only 1 preferred supplier per product).