Help on Append Query

[kwilsokl]

I have a table that has 2 fields called firstname, lastname. It is the master table and all other tables are linked to it by an employeeid.

I have another table called casenotes which I need to add a firstname, lastname field as well. There is already over 400 records in the casenotes table. Which is linked to the master table via the employeeid? I am trying to run a append query to insert the firstname, lastname fields from the master table (employees) to the other table called casenotes. I want the query to insert the firstanme, lastname in the casenotes field that have a corresponding employeeid,

Please help

Thank you

 

[dhookom]

Why? This is generally considered a bad practice since you can always lookup the names in the "master table".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kwilsokl]

The problem is when they create a new casenote in the ASP form I created it does not populate the employeedid. SO I was trying to think of a way they could assign the new record to an existing employee. In access the employeeid is populated in the form since thee is a parent\child relationship. but in ASP when they click add it does not associate the new record with the parent form in the database

 

[dhookom]

This sounds like an ASP question. You can send hidden form controls to your action page. The EmployeeID must be available some where on your form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]