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
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?