table with a subtable?????

[Guest]

hello everyone!
I am have table 2 that compiles our monthly customers with a total amount
of transactions, dates, and some other info. Now, I extracted that table from
Table 1 which specifically details such transactions..(say, date, product,
country, etc.)
What I basically need is bring table 1 into table 2 (subtable?) so if I am
looking at table 2 I can look on detailed form table 1, but only for those
records that are related.....
Too confusing???????

thanks for helping

 

[John Vinson]

hello everyone!
I am have table 2 that compiles our monthly customers with a total amount
of transactions, dates, and some other info. Now, I extracted that table from
Table 1 which specifically details such transactions..(say, date, product,
country, etc.)
What I basically need is bring table 1 into table 2 (subtable?) so if I am
looking at table 2 I can look on detailed form table 1, but only for those
records that are related.....
Too confusing???????

thanks for helping

Table datasheets are of VERY limited utility. I'd recommend that you
use a Form instead.

Try creating a Form based on both tables, using the form wizard;
choose the option to create a Form with a Subform. This will show you
each record on Table1, with the matching Table2 records in a window on
the form.

John W. Vinson[MVP]

 

[del]

John,

I do not see the option to create a from with a subform in the wizard?

 

[John Vinson]

John,

I do not see the option to create a from with a subform in the wizard?

sorry... I basically never use the form wizard; I thought that if you
created a form selecting two tables it would give you that option.

Ok, create a Form for the "one" side table. Then use the Subform tool
on the toolbox, with the magic wand icon selected.

John W. Vinson[MVP]

 

[del]

Thanks John.

sorry... I basically never use the form wizard; I thought that if you
created a form selecting two tables it would give you that option.

Ok, create a Form for the "one" side table. Then use the Subform tool
on the toolbox, with the magic wand icon selected.

John W. Vinson[MVP]