Combine Multiple Tables into One Table

[mattc66 via AccessMonster.com]

I have 4 Tables that I have to combine into 1 Table.

Table 1 = Order Address
Table 2 = Order
Table 3 = Order Details
Table 4 = Order Comments

They are all linked by Order NumberID in each table.

I need to do some sort of Loop table Update.

Does anyone have any suggestions?

 

[Granny Spitz via AccessMonster.com]

I have 4 Tables that I have to combine into 1 Table.

Add all 4 tables in the query design grid. Drag a line from each table's
Order NumberID to the Order NumberID of the one next to it. Double click on
the title bar of each table and drag the highlighted column names into the
bottom grid and go to datasheet view to see if this is what you want. If it
is, go to design view then use Query | Make Table Query to convert it to a
make table query and follow the prompts. Run the query. There is your 1
table.

 

[Granny Spitz via AccessMonster.com]

There is your 1
table.

... Otherwise known as a spreadsheet.

 

[mattc66 via AccessMonster.com]

I think I left out some key details.

AIl flds in the 1 table will be generic. There is 20 fld. This won't make
sense to most Access folks, unless you are familur with the EDI 850 Import.

I need to take this data and export it out in a delimnated format.

I need to place all the data into one sequential table.
The first line will be the Address Detail
Then second line will be the Order
The 3rd line in the table will be the Order Details for the first Item and
each line after that will be on its on record line.
After the OrderDetail will be the comment lines.

Then it loops over again like this for each Order.

Matt

 

[Granny Spitz via AccessMonster.com]

I think I left out some key details.

A *lot* of key details. You can't do this with the built in features of
Access. You need to write a VBA procedure using the Print# statement to
print to a sequential file. I'm signing off for the afternoon so maybe
someone else can help you if you have trouble with the code. You can find
code examples if you google for them.