Ultimate Database

Printer Friendly Page

Login

Relationship Fields

When a relationship is setup between two object lists, various types of inputs can be selected to say how the relationship is presented when the objects are edited.

  1. None
  2. Variable Entry
  3. Combo Box
  4. Check Boxes
  5. Radio Buttons
  6. AUTO HTML/Text Head
  7. ID on HTML/Text Head
  8. Auto Complete Char

You can also setup default values. These can contain the name of the default object to link to or the key words {FIRST} or {LAST} indicating the first or last item in the related list.
They can aslo contain SPVARn to use the SPECIAL variable indicated by n.

Other relationship options can aslo be specified including:-

{DT()}
{OPT_LIM()}
{REL_LEV()}
{OPT_EXP()}
{OPT_EML()}
{STXTREL()}
{}  '* Display Options

Descriptions for the above will follow shortly.

 Useful Links

Google

Bing

W3 Schools

ebay

play.com

amazon.co.uk

DELL

BBC

Rain Today

1and1