Hello,
I have two tables - Vendors and Manufacturers. I wanted to use an append query to append those vondors that are manufacturers as well. I have created an append query and it works but it appends all the records that are not the already there. I set the Company name property as a indexed (no Duplicates) so it will not update the records that are already there but if I have a vendor that is not a manufacturer it appends that record as well.
I was hoping I could make the query record specific. therefore on my form will be a contral that will append only that record. How do I do this - I cannot get my head around it.
Thanks
I have two tables - Vendors and Manufacturers. I wanted to use an append query to append those vondors that are manufacturers as well. I have created an append query and it works but it appends all the records that are not the already there. I set the Company name property as a indexed (no Duplicates) so it will not update the records that are already there but if I have a vendor that is not a manufacturer it appends that record as well.
I was hoping I could make the query record specific. therefore on my form will be a contral that will append only that record. How do I do this - I cannot get my head around it.
Thanks