I have a customer ID as a primary key. I then use that number in my other tables to identify who the order went to . When I run my query it shows the customer id instead of their first and last name. Whenever I set up an auto number (for example 1 is paid and 2 is unpaid, the auto number is always displayed in my queries even though I have the text names in my combo boxes??
Reply from Alex Hedley:
You just need to make a Query where you join the Table with the Description to the IDs.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 1.
