Create table from 2 existing databases, lookup with notes field

R

Rick

I have a database with 2 tables that have similar information. The main
information is what is called a certification number. The other information
is not the same.
I want to create a third table which pulls some but not all information from
the other two. I want the information pulled to be read only that can't be
changed. Then I want to create a new text field in this third table in which
I can type notes. This information in the text field can be edited or
changed.

Can someone help?

Thanks.
 
D

Dennis

You don't need another table. You need a query feeding a form that provides
read-only protection for the fields you don't want edited, and a textbox
control to allow notes to be added.
 
R

Rick

Umm ok
How do I do that?

Dennis said:
You don't need another table. You need a query feeding a form that provides
read-only protection for the fields you don't want edited, and a textbox
control to allow notes to be added.
Click to expand...
 
Top