Append Query

Hi All,

I got a problem to make an ordering databse. Now I have simplified it to 3 tables for testing , they are customer, customer order and product. I used append query to append product table record to customer order table.Criteria was set to show only those records where the Yes/No check box had been selected on product table. As product id(primary key of product table) and customer id(primary key of customer table) are foriegn key in customer order, I append the productid(primary key of product table) to customer order table from product table. On the other hand, I set a default of customer ID is 1 in customer order table then it works. How do I made a specific customer ID rather than using default of customer ID on append query. Pls. advise!

Regards,
IMGary

I added a checked box on customer table and DO NOT add a customer order table to append query. After I checked two checked boxes from customer and product tables and the criteria must checked these two checked box, customer id(from customer table) and product id(from product table) append to customer order. I don't know Y it doesn't work when I put the customer order into append query. Do you know Y?