I apologize in advance for the dumb question, but seems that I have a senior moment here.
I wish to create a view from other 5 views The issue is as follow: I have 5 tables/views which they have the following matching fields ApplicationNo Text 8 PermitNo Text 8 HouseNo Int StreetName Text 30 FullAddress (computed (Ctxt(houseno&streetname)) Each table belongs to a different type of records Because some of the data entry may not be consistent (for example permitno 12345678 may have different address on each table I wish to create a temporary view which have all the (distinct) values of Fulladdress from all the tables where a permitno is equal to xx, but I need to JOIN them so it will be Only one fulladdress column. Any help will be greatly appreciated Robert
