Create table from 2 existing databases, lookup with notes field

  • Thread starter Thread starter Rick
  • Start date Start date
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.
 
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.
 
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...
 
Back
Top