How to organize queries/tables so that I can enter information?

[offie]

I am working with all linked tables (No editing permission). They have employee information.
A quick overview:
I need to show employee information
There are 4 types of employees
-Contract
-Task
-Stand-Alone
-Inspection Service

From the linked tables I get the names for all of the types.


Data for all of the Contract Employees
Indicators for who is a Task Employee

So I've make a query that shows what I want to end up with and leave blanks for the information that I cannot get from the server. This works if someone wants to pull the data and fill the rest out.

But, the thing is, I want to save filled out information in the access file.

I was thinking to make a table with the same fields and join them via union, I'd have to work out a couple kinks but I'm sure I can do it.

Now the thing is.... How would I make it easy for users to enter data into the new table? I want it to look like everything is joined, and have the user fill in what is blank. Is there a way to combine records that you can/cannot edit?

Any ideas?
Thanks!

[June7]

So you use the linked tables as lookups? Should be able to join, don't use INNER join type. However, might just want to use comboboxes to select records from the linked tables.