Combining Several Tables in to One Table

[NDD]

I have 10 tables. None of them have any entries in them. Just field names. Is there a way to combine them all into one table.

 

[NDD]

Yes Sir,
But it isn't giving me a "copy" option. IO was hoping there was a way to combine and merge them. It's ok, I'll just start over. Good practice. THanks for replying.

 

[NDD]

The problem was I had too many fields in my table. I split it into three parts and it worked fine. Now I have to figure out how to link the 3 parts so they stay together.

 

[NDD]

Thank you Pat.

I have nine groups with roughly 4-5 items in each group. Each item has a result out of a possible 4. I put the results in a table and was using a look up for each of the group, as you said like a spread sheet. I am in the process of separating the 4 groups into seperate tables.

 

[NDD]

I don't know what that is, I'm off to do research.

The data is basically the same layout, with different field titles.

If I build the 9 tables, am I right in thinking that using the ID autonumber from table one as a foreign key in the rest of them will link them together?

 

[NDD]

I should add I don't know the first thing about VBA.

 

[NDD]

Here is a piece

 

[NDD]

Here is a bigger piece. The difference between this one and the actual one is I have 3 more tables like the housekeeping table here.

What I would like to do is link the tables together so it makes like one big table.

And build forms, queries and reports so my guys can put the information in themselves and we can use the data.

 

[NDD]

Pat,
I will need to select more than one value in some cases. For example At Risk + Mitigated. In fact that may be the only case.

I will make a copy and remove the relationships.

 

[CJ_London]

At Risk + Mitigated

you could have three options
At Risk
Mitigated
At Risk + Mitigated

 

[NDD]

you could have three options
At Risk
Mitigated
At Risk + Mitigated

Right, I didn't think about that.

Safe
At Risk
At Risk+Mitigated
Not Applicable

That should work.

 

[NDD]

Relationship Removed. This is all but two tables.
I really appreciate the help.

 

[NDD]

Pat,
Did I do what you wanted?

 

[NDD]

I now have all the tbales linked with a key and foreign keys and it's doing pretty much what I want it too. I wrote the values in each table seperately with the look up wizard and it looks right, but one of the tables isn't giving me the little check blocks to select the results. All the others are. Any suggestions?

 

[NDD]

Never mind, it was a "allow multiple values setting"

 

[NDD]

I need to take a class or 10. Now I'm lost. What I am trying to do may not even be the right program.

I have one audit.
Each audit has 12 topics.
Each topic has 5-6 fields.
Each field has 4 possible results.
The possible results are the same for all fields.

I have tried making each topic a table and linking them with foreign keys - too many relationships.

I have tried putting the possible results in a table for the feilds too look up - too many relationships.

I have tried putting all the fields in one table - too many relationships on the results.

I have tried making 3 tables and linking them with foreign keys.

I am less than a novice. I do however really appreciate the attempts to help. I'll go study some more and try again later. Thank you.

 

[NDD]

If you look in the sample templates at issue web database, that is very similar to what I am trying to do. I have followed the instructions to convert it over to client so I can see the design view.

I can't load it in here, it's too big.

 

[NDD]

Ok, I think I can do that. I'll be back. Many thanks.

 

[NDD]

"FieldResult (define a value list NOT A LOOKUP to show the 4 values)"

Could you give some further guidance on this part please.

 

[NDD]

This is what I have so far.