Create TEXT file from table

[Bala]

Hi,

I have imported text file into 4 tables based on the record type (using import specification). All the 4 table structures are different. The link between all the 4 tables are purchase order number. For example in table 1, one record with PO# 123 and in table 2, 4 records with PO# 123 is possible.

Now I want to construct the text file from all the 4 tables (i.e table 1 ,2, 3 & 4). i.e first record from table 1 for the PO# 123 and the next 4 records from table 2
for the PO# 123. How do I do it ?. Can someone please guide me ?

With regards,
Bala

 

[SydneyGeek]

Bala, can you give some more details on the table structures -- what are the fields and primary keys in each table?
Without that, it's difficult to know how to help but you COULD try:
New query in Design view. Place all 4 tables in the query.
In turn, double-click the asterisk (*) for Table 1, Table 2, Table 3 and Table 4. That should give you all the records.

Denis

 

[Bala]

SydneyGeek

Thanks for your reply.

The primary key is purchase order number in each table.

Structure :

Table 1 :

PO#
PO line item #
material #

Table 2 :
PO#
pricing condition

and so on

DATA :

Table 1 :

PO# 123
PO line item # 1
material # abc

Table 2 :
PO# 123
pricing condition pb00

PO# 123
pricing condition pbxx

and so on

The output should be

1231abc
123pb00
123pbxx


pls. help

With regards
Bala

 

[SydneyGeek]

Bala, run the query I mentioned and take a look. If it's what you want, use the Word icon on the toolbar to output it to Word.

Denis