subdatasheet to single table 2

[jenohagen]

I have recieved a few tables. They are related to eachother thru subdatasheets (the plus sign in the left hand corner). I need to remove the plus sign and make them all into one table if possible, not just delete the relationships. At the company I work at another employee did it but he no longer works here. I have been asked to do it. I can tell that he did get rid of some tables and he did remove the some fields from other tables. In the end though he did merge the tables to one table. I dont know if he used sql = "select ..." to move them or what. I have been at this company for 3 months and am still learning access/vba. If it would help I would be more than happy to upload the talbes to some intermediate site for help.

thank you,

 

[KenReay]

You mean make what is commonly called a "flat file" ?

if yes, make a (select) query, using the query designer, yo select all of the columns, joining the table on their relevant relationship columns.

Make this into a "make table" query (designer will do this for you) and run it to create the "flat" table

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[jenohagen]

Yes that is what I want to do make a "flat table". Still learning terminology. I will try the fix and keep everyone posted.

 

[fneily]

You want to merge the tables into one table???? Read:
Fundamentals of Relational Database Design

http://r937.com/relational.html

What you're creating is an Excel spreadsheet, not an Access table. Two structurely different entities.

Or am I missing something? Does your table have any duplicate data?

 

[jenohagen]

Yes there is some duplicate data but there is a primary key that keeps it to a one to many relation. I have made a sql statment that seems to work. I suppose it makes it into a "flat table". So far it seems to work. I will post the code if it will help any other programmers.
The excel sheet im intrested in and would like to look into and I mean that. For this instance I need the data to be kept in a table so the companies program can access it.

thank you again.