"GOAL" :: to use the specific ids of the a single record to auto enter all the other 3 ids when one id is entered into respective table

"accomplishing":: if i enter op_id in the table op_id from record 1of table ids it must have tables that is sym_id, rx_id,fu_id must have the respective ids that is sym_id,rx_id,op_id of record 1 of table called ids hope m clear if not i will try to explain again in better way i guess

4codes.zip

You have not described the real-world process which you are trying to record or model or automate. This makes it nearly impossible to give you an intelligent answer.

• What is the objective of this project?
  
• Are you manually entering the op_id in the ids table from the _ids_xlsx... table? Why?
  
• Is there other data in the _ids_xlsx_sheet1 table that needs to be entered/imported?
  
• What is the reason for four separate tables?
  
• Will the tables have to be related in some way? What is that way?
  
• Is there a reason why you have used 4 different fonts in 3 different colors and 4 different sizes spread over an entire screen to describe your question other than to annoy other readers of the forum?
  
• Is there a reason why you have chosen such a disparaging avatar on a forum to which you have come to ask several different nearrly-unintelligible questions?