Do you have a table of Company records?
You could enter companies as records in your customer table, then a record in the customer table can be a private individual or a company.
Hi, Yes we are biulding up our customer table and have a few entries at the moment.
I have managed to make the company box a drop down like the (bill to) but it doesn't put any of the other information into the other parts of the invoice. It might be me being a bit dim.
The rest of what you want requires that you make changes to your database. There are two approaches you can use, one copies the data into fields in your invoice table, the other just sets up a link to display the current data for that company from the company table: