D
Dave (coloniesonline.co.uk)
Guest
I had a problem with the error (8), but after looking at the
debug option info. It seems that I have been using
the wrong field.. Example:
I had two tables main table being reptype and
the other being old_categories.
I had two fields in reptype one called cat_id
and the other called category. cat_id is a
primary field and category is a varchar to
hold the category description. I created the
other table old_categories to allow choice
in a single choice menu. This worked fine under
2.x, but under 3.x I had problems namely the
(8) error. I made the mistake of turning the
category text field into the single choice
field and linking to the cat_id in the
old_categories table to the cat_id in the main
table reptype. This gave me a error, since
Dadabik linked my text field reptype.categories to
old_categories.cat_id. So I changed the choice field
to reptype.cat_id and now it works. I have removed
the category text field from reptype since it
is no longer needed.
Hope this helps some people.
Dave
debug option info. It seems that I have been using
the wrong field.. Example:
I had two tables main table being reptype and
the other being old_categories.
I had two fields in reptype one called cat_id
and the other called category. cat_id is a
primary field and category is a varchar to
hold the category description. I created the
other table old_categories to allow choice
in a single choice menu. This worked fine under
2.x, but under 3.x I had problems namely the
(8) error. I made the mistake of turning the
category text field into the single choice
field and linking to the cat_id in the
old_categories table to the cat_id in the main
table reptype. This gave me a error, since
Dadabik linked my text field reptype.categories to
old_categories.cat_id. So I changed the choice field
to reptype.cat_id and now it works. I have removed
the category text field from reptype since it
is no longer needed.
Hope this helps some people.
Dave