MS Access VBA text Search records in multible tables in ODBC and import to local tabl

[analyst123456789]

I am developing a UI in Access 2007 using ODBC. The form1 has a logic in order as bellow

1. With search box filled with a list of IDs, on click on the search button (Before.png in attachment)
2. The VBA code will run a query to get corresponding customer_id, customer_name in customer(linked from ODBC) , customer_id, product_name in product (linked from ODBC) and import them into two new local tables. (say the result will be two new local tables customer_LOCAL WITH customer_id and customer_name, product.Local with customer_id and product name)
3. Then display a datasheet on form1 as a search
result that contains customer IDs, customer name, product name (After.png in attachment)

 

[jdraw]

I recommend you start with a clear, plain English description of the business/opportunity involved. Then create the appropriate tables and relationships.
I never see a Form as a first task.

When I see fields named field1, field2 etc. it makes me wonder what the underlying tables and relationships are.
I realize your just posting, but we don't know anything about the database nor business involved.

For readers to understand your situation you might want to use some "real life" data and show the before and after you wish to achieve.

Good luck with your project.

 

[analyst123456789]

I recommend you start with a clear, plain English description of the business/opportunity involved. Then create the appropriate tables and relationships.
I never see a Form as a first task.

When I see fields named field1, field2 etc. it makes me wonder what the underlying tables and relationships are.
I realize your just posting, but we don't know anything about the database nor business involved.

For readers to understand your situation you might want to use some "real life" data and show the before and after you wish to achieve.

Good luck with your project.

Thanks for your comment, I updated my post with a view, hope this time it is clear

 

[Bilbo_Baggins_Esq]

I'm confused analyst.
It sounds like you have laid out your plan and provided screen shots (now).

What specifically is it that you need?
Someone here to actually build it for you?