Save record only if the same exisits in another table

[kamran1514]

table A has 10 records where 1 field is set as REQUIRED/UNIQUE. the table B does not have any record but have a same field like table A. what I want is that if user insert the record in table B it should first check whether record is already present in table A or not, if already exists it should not accept insertion. and if not already there in table A it should insert record in table B. any help in this regard will be highly appreciated.

[stmoong]

You will need to write some VBA code and queries to do that.

Out of curiousity, what is the reason to have such a design?

[kamran1514]

Dear Stmoong, thanks for you reply. can you please tell me that how can I do this with VBA and Queries, please note that I am not very expert in programming but can surely follow your instructions to achieve the goal. the reason to have such design is that database has become very slow. I will highly appreciate if you can tell me the VBA code to fix the problem, thanks.

[stmoong]

Hi kamran, it might be useful for you to learn about programming and simple queries if you want to do this. I don't think it's right for me to type the code for you.

Here's a link to get started: http://www.functionx.com/vbaccess/

Also, use the built-in help file (can be accessed in VB Editor by pressing F1), and also MSDN for reference to the various API.