This will be difficult but bear with me please.
*Customer database - some are monthly, some are quarterly invoiced
*Have a report(invoice) for each due to different method of calculating and both are based on own query based on the parameter of inputting the specific CID.
IOW, on the menu, I have a selection 'Print one invoice for monthly customer'. It has a query that prompts for the CID then populates the report with that record.
I am trying to link these reports from the customer info form so it is possible to print an invoice from there for a new customer just entered.
If I input a new 'monthly' customer, I want to have a command button that will check the field 'BLCAT' (M1 or Q1) then print the monthly invoice with the necessary fields of the current record.
I know this is fuzzy but it's difficult to explain. I am totally lost in trying to do this.
Any help is greatly appreciated.
*Customer database - some are monthly, some are quarterly invoiced
*Have a report(invoice) for each due to different method of calculating and both are based on own query based on the parameter of inputting the specific CID.
IOW, on the menu, I have a selection 'Print one invoice for monthly customer'. It has a query that prompts for the CID then populates the report with that record.
I am trying to link these reports from the customer info form so it is possible to print an invoice from there for a new customer just entered.
If I input a new 'monthly' customer, I want to have a command button that will check the field 'BLCAT' (M1 or Q1) then print the monthly invoice with the necessary fields of the current record.
I know this is fuzzy but it's difficult to explain. I am totally lost in trying to do this.
Any help is greatly appreciated.
