inputing multiple data at once from another table

[Guest]

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

 

[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

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]

 

[Guest]

Thanks alot it worked perfect!!!

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]