link "make-table" queries and form for data entry

[Guest]

I have created an order entry form as well as three "make-table" queries. I
would like the "make-table" query which pulls all the information for the
Customer to run when the Customer ID has been entered into the form. Right
now, when you run the "make-table" query, it pops up a separate window to ask
for the information, and the results won't show in the form. The same goes
for the other two "make table" queries involved in this form. All the
information involved in these queries will be used to create the order and
invoice reports, once the form is completed. I know how to make the separate
pieces, I just can't figure out how to make them intergrate.

If this doesn't make sense, please ask.

Jennifer

 

[Douglas J. Steele]

Why do you need a make table query for data entry? That sounds very unusual
to me...

 

[John Vinson]

I have created an order entry form as well as three "make-table" queries. I
would like the "make-table" query which pulls all the information for the
Customer to run when the Customer ID has been entered into the form. Right
now, when you run the "make-table" query, it pops up a separate window to ask
for the information, and the results won't show in the form. The same goes
for the other two "make table" queries involved in this form. All the
information involved in these queries will be used to create the order and
invoice reports, once the form is completed. I know how to make the separate
pieces, I just can't figure out how to make them intergrate.

If this doesn't make sense, please ask.

Jennifer

It doesn't make sense, not to me.

You may be assuming that you must make a new table in order to create
a Report on that data. This assumption is simply WRONG!

You can - and should - base your Report on a Query, pulling the
information from your existing tables. There is no need to copy that
information redundantly into a new table; in fact, it adds a lot of
overhead processing and database bloat to do so.


John W. Vinson[MVP]