1 Reply Latest reply on Jan 18, 2012 11:02 AM by philmodjunk

    Need help with formula

    shona1

      Title

      Need help with formula

      Post

      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

        • 1. Re: Need help with formula
          philmodjunk

          I need formula to get the "RentalItemsID" based in the entry of the "Group" AND "Ref No"

          I would think that you would eliminate the rev no and group fields from the items table and just define the RentalItemsfk field as a value list of ID codes from Rental Items in field 1 with name or description data from the same table listed in field 2.

          How does the group and ref no relate to an item's ID?