inputing multiple data at once from another table

A

Andrew Slater

Hello,

I was wondering if there is a way to autofill data from one table to
another. Here is the situation. I have a database full of alumni that need to
be invoiced. There are two tables my alumni table and my invoice table.

In my alumni table i have it set upsome fields by status (Active, Nonactive,
etc), Alumni No, confirmed addresses, and other information. I want to be
able to automatically create invoices for based upon only if they have an
active status and confirmed address. Is this possible?

Andy
 
J

John Vinson

On Thu, 8 Sep 2005 05:23:06 -0700, "Andrew Slater" <Andrew
Hello,

I was wondering if there is a way to autofill data from one table to
another. Here is the situation. I have a database full of alumni that need to
be invoiced. There are two tables my alumni table and my invoice table.

In my alumni table i have it set upsome fields by status (Active, Nonactive,
etc), Alumni No, confirmed addresses, and other information. I want to be
able to automatically create invoices for based upon only if they have an
active status and confirmed address. Is this possible?

Andy
Click to expand...

Well, certainly; but you would NOT do it by copying the all the data
in the alumni table into the invoice table.

You're using a relational database. Use it relationally! Your Alumni
table would have fields like the AlumniID (the Primary Key field), the
person's name, address, graduation year, and so on. The Invoice table
should contain ONLY the AlumniID from that table - and *none* of the
other data about the alumnus/alumna. It would have fields about the
invoice itself - invoice date, amount invoiced, etc.

I'd suggest running an Append query based on the Alumni table to
populate the invoice table. Use criteria on the status and address
confirmation fields to select only those records which should be
invoiced.

Your actual invoice printouts would be based on a Query joining the
two tables - you'ld pull the alumni's personal information from the
Alumni table, and the invoice information from the invoice table.

John W. Vinson[MVP]
 
A

Andrew Slater

Thanks alot it worked perfect!!!



John Vinson said:
On Thu, 8 Sep 2005 05:23:06 -0700, "Andrew Slater" <Andrew


Well, certainly; but you would NOT do it by copying the all the data
in the alumni table into the invoice table.

You're using a relational database. Use it relationally! Your Alumni
table would have fields like the AlumniID (the Primary Key field), the
person's name, address, graduation year, and so on. The Invoice table
should contain ONLY the AlumniID from that table - and *none* of the
other data about the alumnus/alumna. It would have fields about the
invoice itself - invoice date, amount invoiced, etc.

I'd suggest running an Append query based on the Alumni table to
populate the invoice table. Use criteria on the status and address
confirmation fields to select only those records which should be
invoiced.

Your actual invoice printouts would be based on a Query joining the
two tables - you'ld pull the alumni's personal information from the
Alumni table, and the invoice information from the invoice table.

John W. Vinson[MVP]
Click to expand...
 
Top