FOCUS
FOCUS relies on the 3 letter abbreviations and a unique number for each
table (kind of like you would have in an accounting program). You need to enter
this information into the TABLE table. I know it looks
like I just made a typo, but that is correct. The Table tab is the second icon
from the left (the thing that looks like a solar panel). To create a record,
click the red square with a green plus sign. This will create a new record in
the TABLE table. Next, enter a 3 letter abbreviation and a unique index number
for this table.
So let’s say you were to add a new table to this database – before you get the urge to dive headfirst into the define database dialog, create your record in the TABLE table.Once you know you have a valid 3 letter code, then go ahead and add your new table into the schema of your database. In this case, we are ready to add a new PROJECT table.
All table names, field names, and table occurrence names are UPPERCASE. Each table will have a primary key field named ID with the following calculation (note 3 letter prefix at the beginning of the calculation). This ID creation was inspired by some research that Ray Cologon did to generate unique ids (so credit goes to him).
"" Upper ( NIC_CREATED ) "" Get ( RecordID ) "" GetAsNumber ( Get ( CurrentHostTimeStamp ) )
NOTE: In theory, this approach can allow for users to take offline copies of the database and have users create data and merge data back into the solution without any record conflicts and keeping each record uniquely identified. This has not yet been fully tested and used in a production environment.
Here is a handy checklist of things you must do.
/groups/focus/search/index.rss?tag=hotlist/groups/focus/search/?tag=hotWhat’s HotHotListHot!?tag=hot0/groups/focus/sidebar/HotListNo items tagged with hot.hot/groups/focus/search/index.rss?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomelist/groups/focus/search/?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomeRecent ChangesRecentChangesListUpdates?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcome0/groups/focus/sidebar/RecentChangesListmodifiedDateallRecent ChangesRecentChangesListUpdateswiki/welcomeNo recent changes.reverse5search
Comments