bj55

I have 3 files linked, i.e. Addresses, Services, and Bills. Services lists unique IDs, their text Descriptions, and 7 different price groups. Customer_Status, which defines price group, is required entry in Addresses. Lookup based on Customer_Status enters prices for each service into Bills of 20 lines max. for each Day. Services for several days are later linked via Bill_No to print as one Bill. Problem: Bills, like individual quotes, are correct when viewed/printed in the correct one of seven layouts, one for each group of customers of the same status. So far, I have a Warning field which displays a message if the layout does not reflect correct Customer_Status. I need to keep wrong quotes or bills, i.e. wrong layouts for this customer, from showing up altogether. Or, is there a way to have all 7 groups share the same layout? If so, it would immensely help with problem no. 2: As mentioned, price quotes are entered via lookup to be alterable. Similarly, Descriptions get modified, sometimes considerably. I provide 4 menued fields for "patchwork" comments ("large," "small," "left," "right," etc.), which will appear after the basic description on the same line through text calculation. This now requires too many fields with too many mistakes possible. Any advice for this newbie would be greatly appreciated

I have 3 files linked, i.e. Addresses, Services, and Bills. Services lists unique IDs, their text Descriptions, and 7 different price groups. Customer_Status, which defines price group, is required entry in Addresses. Lookup based on Customer_Status enters prices for each service into Bills of 20 lines max. for each Day. Services for several days are later linked via Bill_No to print as one Bill. Problem: Bills, like individual quotes, are correct when viewed/printed in the correct one of seven layouts, one for each group of customers of the same status. So far, I have a Warning field which displays a message if the layout does not reflect correct Customer_Status. I need to keep wrong quotes or bills, i.e. wrong layouts for this customer, from showing up altogether. Or, is there a way to have all 7 groups share the same layout? If so, it would immensely help with problem no. 2: As mentioned, price quotes are entered via lookup to be alterable. Similarly, Descriptions get modified, sometimes considerably. I provide 4 menued fields for "patchwork" comments ("large," "small," "left," "right," etc.), which will appear after the basic description on the same line through text calculation. This now requires too many fields with too many mistakes possible. Any advice for this newbie would be greatly appreciated

I have 3 files linked, i.e. Addresses, Services, and Bills. Services lists unique IDs, their text Descriptions, and 7 different price groups. Customer_Status, which defines price group, is required entry in Addresses. Lookup based on Customer_Status enters prices for each service into Bills of 20 lines max. for each Day. Services for several days are later linked via Bill_No to print as one Bill. Problem: Bills, like individual quotes, are correct when viewed/printed in the correct one of seven layouts, one for each group of customers of the same status. So far, I have a Warning field which displays a message if the layout does not reflect correct Customer_Status. I need to keep wrong quotes or bills, i.e. wrong layouts for this customer, from showing up altogether. Or, is there a way to have all 7 groups share the same layout? If so, it would immensely help with problem no. 2: As mentioned, price quotes are entered via lookup to be alterable. Similarly, Descriptions get modified, sometimes considerably. I provide 4 menued fields for "patchwork" comments ("large," "small," "left," "right," etc.), which will appear after the basic description on the same line through text calculation. This now requires too many fields with too many mistakes possible. Any advice for this newbie would be greatly appreciated