AnsweredAssumed Answered

Related Table Field Not Showing on Form View

Question asked by edchua on May 18, 2014
Latest reply on May 29, 2014 by philmodjunk

Summary

Related Table Field Not Showing on Form View

Product

FileMaker Pro

Version

13

Operating system version

Windows 7

Description of the issue

I created two tables. First is called "Asset" with the following fields.
AssetID (number, Auto)
AssetName (text)
rentPerHour (number).

Second table is named "Rental" with the following fields.
AssetID (number)
StartDate (date)
hoursUsed (number)
AmountDue (calculation, defined as hoursUse*Asset::rentPerHour)

The two tables are related via the AssetID.

Steps to reproduce the problem

Layout are as follows:

AssetID   (edit box)
StartDate (edit box)
hoursUsed (edit box)
AmountDue  (edit box)

Expected result

I am expecting to see something like this with the AmountDue calculated.

AssetID : 001
StartDate : 03-15-2014
hoursUsed : 60
AmountDue : 3,500

Actual result

But instead, FileMaker has completely ignored the calculation field. The AmountDue remained to be zero. Seems like FileMaker has a bug. I had reviewed the table design, relationship more than ten times but to no avail.


AssetID : 001
StartDate : 03-15-2014
hoursUsed : 60
AmountDue : 0

Exact text of any error message(s) that appear

No error message shown or reported.

Outcomes