AnsweredAssumed Answered

Need help with formula

Question asked by shona1 on Jan 18, 2012
Latest reply on Jan 18, 2012 by philmodjunk


Need help with formula


I need a formula for my rental items entry. I have one table for the "Rental Items" with the feilds "RentalItemsIDpk" "Group" and "Ref No" Then I have a  table "Rental Line entry" with the fields "Group" "Ref No." "RentalItemsfk" One the  Layout the "Group" field  is set up as a Value list from the "Rental Items Table:Group" and Ref No. is our ref which can be dupilcated but not in the same "Group". I need formula to get the "RentalItemsID" based in the entry of the "Group" AND "Ref No" Yes I am completely new to FM