bobsmallwood
Programmer
Is there a way to configure a lookup table so that a value in it is not REQUIRED by the referencing table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lookup Table - "Unfound" value entries
- Thread starter bobsmallwood
- Start date
- Status
TonyMcGuire
Programmer
See the 'lookup table' custom form about halfway down the page.
I think with this form you could set it up any way you wanted. But you would have to customize it, I think.
Tony McGuire
If the lookup is on a single field, then a drop-own list might be an option.
Even if the list is automatically populated by a table, it is relatively easy to add items to that table using a little code; so if the user types in a value that doesn't currently appear in the list, it is available next time.
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
Even if the list is automatically populated by a table, it is relatively easy to add items to that table using a little code; so if the user types in a value that doesn't currently appear in the list, it is available next time.
Mac
"There are only 10 kinds of people in this world... those who understand binary and those who don't"
langley_mckelvy@cd4.co.harris.tx.us
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question