Search and Select from two tables and pass the result to a third table

[raghuram]

I need to look for an account number (entered by the user) in Table 1. If not found, look in Table 2. If not found there also, Error Message.

If found, pass that account number to Table 3 to populate more prompts on the prompt page. How do I do this?

[raghuram]

More info on Tables 1 and 2. The Count(*) is as follows:

1.  Table 1: 31228
2.  Table 2: 51844
3.  Full Join of Tables 1 and 2 on Account_Number: 65672

[blom0344]

Write a stored procedure? You are basically describing data manipulation,not reporting. Passing data from table to table is not a BI purpose. You need to handle this within the database

[raghuram]

Thank you for the tip. I don't have access to the database and need to jump through couple of hoops to get the stored procedure(s) done.

I did get the issue resolved with the Search and Select Prompt though.

I will keep the idea of Stored Procedure in mind and try it sometime down the road based on the access to the database.