What I am trying to do is created a invoice form that has the following information.
Cust-Table - to pull Cust.fname & Cust.lname by the (CID)
Prod-Table - to pull Prod.Desc and Prod.Cost by the (PCODE)
Invo-Table - Maintains
[INVN] for invoice number
[INVD] for invoice date
[CID] - Is a forigen key for Customer
[PCODE] - Is a foigen key for Products
[QTY] for Item qty.
..............................................................................................
My problem is that I can't seem to get the feilds to update
properly. When the form starts it already has a record in it
but I want a blank form. next when I change the CID#
I can get the Name to change, but when I pull up products
my grid does not operate like it should and the items
are some times incorrect.

Yes I am a newbee, but I am trying..

Thank for any assistance..Please email me an
example if you have one so that I am study it.

Mike D.