simple address db question
i agree with both of you - back to the drawing board
--
deb
"Jeff Boyce" wrote:
Deb
Perhaps it is only a matter of semantics ...
You definitely do NOT want to do this directly in the table.
If you are saying that you have a table with a field defined as a lookup
field, stop now! Lookup fields in tables have two strikes against them ...
first, lookup fields store the ID, but display the looked up value. This
causes considerable confusion.
Second, working directly in tables is a common approach ... if you know
spreadsheets. But in Access, tables store data, and forms display it. Use
the forms.
Good luck!
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"deb" wrote in message
...
i know in the back of my mind i know how to do this but...
when i select the suburb in the lookup field i need the table to
automatically update the postcode and state field from the lookup table -
like a vlookup function in excel
help
--
deb
.
|