Hi babs,
Just add a foreign key in your quote table = Invoice ID. Other than that the
tables are separate, each would have CustomerID, JobID ... whatever links the
each one needs for the info. To create an invoice from a quote you could put
a command button on the quote that runs an append query.
Roger
babs wrote:
I really want the two seperate forms. One for quotes and one for Invoices.
Re read above - having problems linking these tables. Currently have the
Invoices table would like to add a field to the invoice table called quoteid
as a drop down. If there is a quote for an order they can choose a quoteid
from the drop down and it will automatically fill in SOME of the fields. So
Invoice person does not have to.
Thanks for your follow up,
Barb
I am sorry, I scanned quick and I thought you were re-asking how to make
controls visible or not visible. But the above does answer your original
[quoted text clipped - 7 lines]
Roger
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200512/1