Automatic Data Entry

[Kim Kohen]

G'day Peter

> My guess would be Filemaker background (globals from Filemaker). I've
> seen a lot of Filemaker developers trying to do this when switching to
> another database system. It's not a good practice, that's for sure.
€€€€
It's really common within the FileMaker community to use global fields to
store regularly used values or to create interface tricks that are not
otherwise available.

One of the most common uses is to create a relationship to a global to allow
portals to appear or disappear depending on the value of the non-constant
field. They're also often used as 'placeholders' in a calc field eg. Have
some HTML tags in a global and then calc it into some DB data for use on a
web page.

I know it appears strange to people who haven't done it, but then I find it
really strange that I can't create my own Primary Key.

Cheers

Kim