I have an enquiry regarding the use of invoices. Again I apologise I cant post an example..... hopefully below gives you the idea.
I've created drop down lists for a customer id in the top of an invoice near the date, this then auto fills the customers Company.... but I can only make it fill in one single line.
Selecting customer Id : ABC
Auto fills the company name ABC Cleaning Contractors
but doesn't allow for the subsequent lines, ie address, phone number web site..
ABC Cleaning Contractors
123 Bright Street, Spotlessville, NSW 2000
T: 9999 1234
I've tried a heap of different ways and formula's like IFS to auto populate the name but cant make it work with more than one line..... Any ideas? Ideally a customer card or similar with details on it????