Complicated Table Creation Help Needed

[BukHix]

I am back working in Access again and I have a very complicated problem. I am not even sure there is going to be an automated solution to this but if there is I need help figuring out how to do it.

I have two tables that I need to make into one new table. Table A is the primary table. It has a list of all our project numbers and their associated phase codes. For instance:

Next Table B has a list of all the Phase Codes along with a list of associated Cost Codes like this.

Now here is the tricky part. Table C needs to be created like this. For each job and phase pair there are these Cost Types. Graphically it looks like this:

Does that make sense? Is it possible? Any suggestions to how I should go about tackling this? Thanks in advance.

 

[BukHix]

Pat to be honest I don't have very good answers to most of your questions. The structure of the tables were pre created by an accounting package vendor my employer uses.

I am in the process of bringing all our data out of a proprietary database format and into a SQL Server back end. Most of the conversion process has been pretty smooth but this one has got me stumped. I am given comma delimited files and blank (pre built) tables to work with. Luckily for me the company that built the old software package also built the new one so the field names are pretty consistent throughout.

As far as embedding the images that was the easy part. I used (Win2k’s) Shift Print Screen, pasted it to Paint Shop Pro, cut out the parts I wanted to show, uploaded them to my web space and then used the IMG tags that this forum supports. I couldn't think of a better way to get the concept of what I needed to do across in this post.

Oh yea, one more thing. I did email the database to someone on this forum (per request) to take a look at it so there may be a solution in the works. If so I will post an update to this thread.

UPDATE: I think I have a working solution to this now. Unfortunately I don't know the UserName of the person who figured out the solution and I am not sure he would want me to use his real name so "You know who you are" thank you very much for the help.

I won't be able to put the solution to the test until Monday so I may be back to this thread then.