Hello
I have table Name "A" as master table, other lookup tables are "B","C", "D", "E" and they are joined using primary and foreign key relationship.
Now I am creating a query manually using query design to get required field from lookup table, but when I am creating a query it returns couple of fields from lookup table with table name, for example tbl_a.firstname
Can anybody please help me why this is happening this is not happening with all the fields from specific table but for few fields only.
Thanks
DJD
I have table Name "A" as master table, other lookup tables are "B","C", "D", "E" and they are joined using primary and foreign key relationship.
Now I am creating a query manually using query design to get required field from lookup table, but when I am creating a query it returns couple of fields from lookup table with table name, for example tbl_a.firstname
Can anybody please help me why this is happening this is not happening with all the fields from specific table but for few fields only.
Thanks
DJD