hello, i've this problem:
- i've 1 table (colour-> id, colour, photo) and another table (products-> id, product, photo, list_of_colours);
i'd like to make this:
i go in the "add" page for products, i choose from a lookup wizard (size 10) some record from colours, and i store this values into the field list_of_colour (mediumtext);
when i try it, in the lookup wizard i can't use in the "Link Field" option the "id" field, so i obtain a list_of_colours field that contains a list of colours by name and not by id (example i obtain a field: "orange,yellow,green" instead i like obtain "3,5,8).
How can i do? why i can't use the field "id" in the "Link Field" option in the Lookup Wizard Screen?
Sorry for my imperfect english! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4925&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
