Hi there
I am having some trouble with Access that I hope you can help with.
I currently have two tables.
CUSTOMERTABLE:
PK - cust_id
firstname
lastname
street
city
state
postcode
ORDERTABLE
PK - order_id
product_id
prod_descrip
prod_price
I am trying to set them up in a relationship and am wondering if it's possible to add the cust_id as a foreign key in the ORDERTABLE? I can link up cust_id with order_id in a relationship but the cust_id doesn't move across as a foreign key like it does in Visio. Is this possible to do?
Many thanks for your help!