Hi all,


  I expreienced an problem which i feel new ..
 Iam having an table which having relation with other tables i.e.
 Iam having an Table called Employee name and it contain name of the Employee...and it have an primary key called Employee ID and i did the relation to the main to and the filed as Employee ID and the type of field is Number and i use combo box for its front end..i.e. from ! . Now the probs is when i creat the query and run it the result give the employee name but when i export it display the ID number in the excel sheet iam not having any idea about this issue..

 pls help me in this issue

pap

Hi,

   What you need to do is in the query designer, you need to show both tables, and don't select the Foreign Key in the one table, but use the name from the employee table.

   For example, using similar tables, instead of:

SELECT Order.CustomerID, Order.OrderID, Order.Item, Order.Qty
FROM Order

   (this will show the Customer name in the query, but will only export the CustomerID)

   DO this instead:

SELECT Customer.LastName, Customer.FirstName, Order.OrderID, Order.Item, Order.Qty
FROM Customer JOIN Order etc.

This will show the Customer FirstName and LastName (You can do [LastName] & ", " & [FirstName] As Name, etc) when you export the query results.

The important thing is to show the fields you want from the tables you want, and not the relationship fields in your queries. You will also get other negative results when creating reports etc.

Did this help?



mmcdonal