form based on table data help

[Guest]

I have a table that has ID field which is (autonumber); Procedure-Number,
which is a lookup field from Procedure_list table; and Procedure-Name which
is also a lookup from Procedure_list table. What I want to do is have a form
that once the procedure number is selected then the procedure name is
automatically pops in to the field for it. How can I do that? Can anyone
help me on this task?

Thank you,

 

[Guest]

Hi Judy,

I suggest using field names that do not include special characters, such as
the hyphen (can be interpreted as subtraction). The fields Procedure-Number
and Procedure-Name would be better named ProcedureNumber and ProcedureName,
respectively.

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

The ProcedureName field sounds to me like it is redundant information in the
Procedure_list table, since [Procedure-Number] is a lookup. The only reason
you might need to store Procedure-Name reduntantly is if it is subject to
change over time, and you want to record it's value at that point in time.

Here is a past thread in Google, where I showed a user how to accomplish as
similar task, using the sample Northwind database (Northwind.mdb) that you
likely already have installed on your computer:

http://groups.google.com/group/micr..._frm/thread/d9aa979b504a3f3f/71321e962a88e49c

Try those directions out on your copy of Northwind. Then see if you can
apply it to your database.

Similar threads here:
http://groups.google.com/groups?as_...05&as_maxd=16&as_maxm=4&as_maxy=2007&safe=off


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________