Recent content by emc2

FOR ONE INVOICE, I NEED THE ENTIRE TABLE-Desc, indexes 1,2,3,4and 4. The Invoice has over 40 fields these are only 4 of them. I have 4 job indicators which if "ON" I have to get the jobdesc fr the Table-Desc . If none of the 4 are "ON", I simply use Table-Invoice NOTES field in the center of...

The Invoice has over 40 fields these are only 4 of them. I have 4 job indicators which if "ON" I have to get the jobdesc fr the Table-Desc . If none of the 4 are "ON", I simply use Table-Invoice NOTES field in the center of my report/printed invoice. BUT if IND1 is "ON", I have to get the...

If an certain indicators ="x" in my invoice form, I want to go to the DESCRIPTION table to get the standard verbiage for that job to then put it in the report/invoice text box. I DO NOT want to store it in the invoice table. I do not know how to set up a relationship to the invoice table; I...

NO this is DETAIL for ONE/EACH invoice/job. This construction firm wants to use the same general long description for PAINTING ie warranting etc, ditto another distinct desc for SEALING, another for PRESSURE CLEANING, & another for PREP... BUT they do not want to have to type all that...

Simple Customer table <CustomerID pk>, Invoice Table <InvoiceID pk, CustomerID fk> Form/subForm which propagates all 45 fields to Report2 <an Invoice> fields except some descriptions which I have to retrieve from a description table: Table1-Desc: DescID pk <1-4>,DescName <"Sealing" "Painting"...