In my invoicing database, I have it set so if you enter an account number it uses that as a look-up to fill out the company name and address fields on that invoice. What I'd like to do in addition to this is set it up so that if someone enters a company name, it looks up the account number for them and thus fills out the address, etc. I'm actually not limited to doing it this way, I basically want to be able to automatically fill out company info whether I enter an account number or company name. Using 2 different relationships on the same file doesn't work -- it always says this lookup includes the field in its definition. Yet one lookup uses account number and the one I'm trying to use to lookup the account number uses company name. Anyway around this without using 3rd-party software?

I prefer to start in the customer table and create a new invoice from there. This covers the case when you have a new customer or the customer data changes.

I don't know of anyway to do what you want to do.