Forum Discussion

Re: Application variables

Make field of type formula numeric.
put a 1 in the formula box as a formula.

Not surprisingly, it will always calculate the result to be 1.

The point is that the settings table has a record ID# of 1 in its one and only record.so to match up with that your child table, the child table also needs to have a 1 in it to make the relationship lookup the correct record from the settings table.
No RepliesBe the first to reply