Hi friends.
Here is my DB.
table1 > table2 (many to one)
table1 > table3 (many to one)
These are not linked with foreign keys, or anything.
I built a project with table1 "looking up" (dropdown box) in tables 2 and 3, and enabled "add on the fly".
The problem is....the look-up works perfectly with table 3, but not table 2 (tables 2 and 3 have identical structure). When I open table1 (in my browser), click "inline edit" and then "add new" for the field2 (table 2), I get a pop-up without any text boxes. It's the same if I click "add new" from the top menu > this opens table1_add.php, again click on "add new" and there are no text boxes to enter the new field.
As I already said, for table 3 this works perfectly.
Can anyone shed any light on this or direct me to where I can find the two bits of code (ie. in which file and what does it look like), so I can go and compare and see what is going on.
I did manage a workaround, changing "dropdown box" to "list page with search" (although the search part didn't work!), but I don't like this method (find it hard to use).
Final question - on the visual editor > look up page, there is a checkbox "unique field". Sounds pretty obvious what this should do (couldn't find it in the manual or help file), but I couldn't get this to work or do anything.
Thanks for any input,
Shankar.
EDIT: OK, don't know what the problem was - tried resetting in visual editor and rebuidling (didn't work), but fixed it by removing table2, closing and saving project, re-opening, re-adding table2 and then rebuilding.