A button for an append query

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

Hi All
Here is the situation: I have a table that I store data about a prospective
customer until Some work is done for them. The table has baically the same
fields as my perminant table which I use to create Work Orders and Invoices
from.
What I need is a button on the form where I am viewing the data on the
prospective customer so I can then Append this data to the perminant
customer data table.
Can some one direct me as to how to create an append query, or code for that
button on the form to perform this action. Or direct me to somewhere for
this info.
I hope I am explaining this ok.

Thanks
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Your table design is incorrect. In the permanent Customer table you can
have a "Potential" column (Yes/No) with a default of Yes, which makes
all new customers potential customers. When the customer makes an order
change the Potential value to No.

Using this design you will not need 2 tables. You will only need 1
form: you can filter the form for potential/non-potential customers.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJaMsIechKqOuFEgEQKeUwCg6ptYuiQd0BV/rdVnZgmf4LD9eh8AoKJI
V1dVzYIuFZ8JOFNzhf8wmYNH
=yMJK
-----END PGP SIGNATURE-----
 
Back
Top