Append table fields to different tables

[brucewalker]

I need to append records from a table to three other tables. I imported the spreadsheet into my database and then created a query to pull the fields I needed from the imported table in the query. The query pulls records for fifiteen different fields. I then change the query type to an append query and chose the fields i needed to append to the first table. I then change the append query to append the fields I need to the second table, and then the third table. The records for these fields are now in each of the three tables I needed them in, but I have a problem. I have a form which ia based on the three tables and when I try to search for the records I just added it does not find them. I get the message that the search item wwas not found. If I open the table and search the table it will find the record. What have I done wrong??? Thanks.

 

[JHB]

What is the RecordSource for the form?
Did you try to close the for and then open it again?

 

[brucewalker]

The record source for the form is a query based on three tables. Yes I have closed and re-opened the form. I think the problem is related to the fact that one of these tables originally contained all the data related to custoer orders. I used the table analyzer to split the main table into smaller tables containing just specific data. When I did that it put lookup fields into the original table. So there is a reference to all the original data. The customer name and address information still goes into the orginal table, but when I appended the new records there is no reference in the lookup fields to the related data in the other tables. That is what I need to fix. Thanks.