A difficult question (1)

[Steveanderson]

I have tried to find the solution to this problem for several days but I still can't figure it out:

I have two tables
Table 1 (more than 1 million records)
Fields A / B /C /D

Table 2 (several thousand records)
Fields A / 1 / 2 / 3

The field A is a unique identifyer that could be used to link both tables

I want to create a Table 3 which includes field A and any other fields from table 1 or 2. These extra fields should be selected through a combobox.

How do I create this new table while maintaining the link to the data ?

Thansk in advance

 

[dkinley]

If it is just a one-off then you can use a make table query to do this. Then you can be selective about the mixing and matching of fields in the QBE to be used in the new table.

I am not sure of the whole using combo box stuff or why you would want to do that. Now if the scenario is that you will need to make different tables on a daily basis and the mix and match needs to be done by a user then perhaps you are wanting something to simulate MS Biz Obj?

Does it have to be in a table? Are you exporting it out in the table form or perhaps in Excel?

Again, the simplest approach is to create a new query, select make table (input the name), put your tables on the QBE, create the link (if not already done for you), add the fields you want and run.

-dK

 

[Steveanderson]

The whole Ideal is that users will be able to create access tables selecting only the fields they require (to have smaller files)
I tried working with queries but there are too many variables here

 

[dkinley]

I tried working with queries but there are too many variables here

But you'd rather complicate (and upsizing) the database by creating more tables with the same amount of variables? ... and creating mass duplicates of data you already have?

I am not either understanding the logic or not understanding the goal(s) of the mission.

You can use queries and have those export right to a spreadsheet (thus having smaller spreadsheet sizes) and not effect your dataset. You can even make dynamic queries on the fly by letting the user select the data they want to export and go a step further and let them save it (there are examples out there - 'dynamic queries').

Anyhow, regardless of what is needed - here are some tutorials with sample code to help you along the way:

http://www.accessmvp.com/strive4peace/
http://www.vtc.com/products/Microsof...-tutorials.htm
http://fisher.osu.edu/~muhanna_1/837/MSAccess/
http://www.functionx.com/
http://knol.google.com/k/data-entry-in-microsoft-access#
http://www.sienaheights.edu/personal...Access2007.htm

HTH,
-dK