need help please

[Scotty66]

Ok here it is

I have 5 data bases which build a large list of names. Main issue is all 5
build unique names which are used to store data to smaller subgroup items. I
need to build a data base that I can added these smaller subgroups to (to
each name) and it grows and adjusts as each of the 5 main data bases do. The
wizard keeps trying to do this for me but I am soooo lost in what its trying
to do.

I run a query and got 2 of the 5 data base name extracted but it made a
lookup list in the new database and did not add them in the rows, which is
what I need, to get these new subgroups in to the data base. With out filling
all 5 databases with repeating information. See layout below

Database1 Database2 Database3 Database4 Database5
Name group1 Name group2 Namegroup3 Namegroup4 Namegroup5

(Each database, stores information based on its main grouping. which is why
there are 5 of them, each has a unique name in it, which I want to pull out
to build a new data base or have it reference those names to add the new
subgroup information to each name)

So in short I have 5 lists of names I need to add more data to “subgroupsâ€

I want to store all subgroup information in this last database. So I will
have 5 main groups, then 1 subgroup database. I need the last one to build
off the names. Please someone help me I am not sure this can be done, but the
wizard keeps trying too. And all it makes is a lookup list; this is not what
I need.


This is for a warehouse inventory – very large, and got a very large headache

Any help would be great or just point m e down the write road,

 

[Wayne-I-M]

Sorry but I am a little confused.

Is this right ?

You have 5 databases that ytou want to combine into one.
At the moment you have linked tables (your sub groups)
or
You are adding the list of names to a query (somewhere) and then grouping
these somehow (by name-address-etc)

Can you explain it in a different way

 

[Scotty66]

yes i was real tired when i wrote that, sorry

i have 5 data bases which have "names" in them- the names of items in
inventory
i need to get those 5 list of names to merge into 1 data base so i can build
a subcatagory data base, beased of those names

i have tryed to use wizard and it wants me to but can not get it to work,
not sure if going down wrong path

i hope that is simple and to the point , note to self not to write when been
up all night

again any help would be great

 

[Wayne-I-M]

1st things 1st. To get all your record into 1 database

I think you may have tried this alread but (simple ideas 1st)

Have you tried using Get External Data
Have you tried to copy the records and paste them into a new database table

 

[Scotty66]

no i have not tried to get external data, as for copying them , its over
20,000. that would take forever, dont got that much time.

have not tryed the external data, but have used make-table query , that has
not worked can get 1 list in to new table but can not get the rest in, have
added 1 at time to it and just makes them i 2 colums that is not working to
well. so i will have to read up some more , never did anything with external
data before, been long itme sence classes. any help on that would be great,
also will that give me all the names in 1 data base?