By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Multiple default values - how?

P: n/a
Dear All,

I would like to have multiple default values for a field in TableA, which
are stored in a separate table (TableB), and can be automatically selected
depending on the value of another field in Table A. Could anyone show me how
to approach this problem?

Also, how can I have a default value with a more complex structure for a
field? Something like this:

Something
Indented something
Another thing

So, something with line breaks and tabs...

Any help is appreciated...
Viktor
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think you're confusing the concepts of defaults and lookups.

If I understand correctly what you are wanting to do (automatically choose
one value for FieldA when the value in FieldB changes, but permit overwrites
to that automatic choice), you will need to use a form to do this - it can't
be done at the table level.

HTH
- Turtle

"Viktor Lakics" <la*****@ntlworld.com> wrote in message
news:82****************@newsfep2-gui.server.ntli.net...
Dear All,

I would like to have multiple default values for a field in TableA, which
are stored in a separate table (TableB), and can be automatically selected
depending on the value of another field in Table A. Could anyone show me how to approach this problem?

Also, how can I have a default value with a more complex structure for a
field? Something like this:

Something
Indented something
Another thing

So, something with line breaks and tabs...

Any help is appreciated...
Viktor

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.