I have the following situation. I have a form that contains an invoice table that has an customer id plus an invoice id. The problem is that the customer id may refer to either a subscriber table or a customer table. Unfortunately when this was originally designed the end user decide to keep them separate. At my suggestion I said let have a table for addresses which has the id for both subscriber and customer and then have another table which contains additional information for the subscriber. The only other information we keep about the customer is in the invoice table. We have subscriber who can order product plus outside customer who aren't subscriber can also order products. Anyhow it is too late to resolve that issue. Anyhow what I need to do is to create a lookup form that will pull the address information from both the subscriber and customer table plus information from the invoice table. I am not sure how large a record set I will be dealing with for the invoice table but I do know the subscriber table is about a million records. I don't believe I will be able to use a SQL statement at least not that I know because it would contain nulls. Am I better off create a lookup table which will store the information I need for lookup. Would that also be faster than using any view or sql.