Default values

[cbuechner]

I am trying to make sure I am doing my homework prior to asking any question.



IM just going to ask a basic capability question. Is it possible to get the default value from a different table in table design mode?

[mike60smart]

Hi
If you need to get a value from another table then you would need to set the DataType of the Field to a Number, Long Integer

Then on the Form that is bound to the Table you would create a Combobox to Lookup the values from the other table.

[Micron]

Is it possible to get the default value from a different table in table design mode?

Strictly speaking, pretty sure the answer is no.

you would need to set the DataType of the Field to a Number

Why? Default can be text too.

[Gicu]

Not in table design but it is trivial in a form bound to the table. If you really need to do it in a table I believe you can achieve that using a data macro AfterInsert to call a custom VBA function (in which you can get the values from the other table using simple dLookups).
Cheers,

[apr pillai]

If you go for the Combobox or Listbox Options then you can do it in the Table design time itself. The Table Field Property Sheet have two tabs, the second one is the Lookup Tab. On the Lookup Tab we have the ListBox and Combobox Options besides the default TextBox.

If the Default value is a Constant then we can assign it on the General Tab itself.

I know these things are not anything new, just thought of refreshing my memory.