I've set up a table for the products we sell. Their description, size, colour cost etc. I am trying to set up a look up relationship for the category that I want the product to be filed under. I am trying to set up a lookup relationship between the product field and the category field but however I try to do it I can't seem to get it to work.
In the product table I'ce set up a field called category. It's a text field and I've set it up to lookup the Category in the Category table. I've joined the category fields in each table but this doesn't work. When I've done this the category field in the product table won't allow the cursor to work in this field.
Has anyone any suggestions what I have done wrong?