Look Ups Not Looking Up...
Posted: 2014-05-14 18:17
I hope that the knowledgeable people on this forum might be able to help a relative newcomer.
I have created a simple database with Appgini where a number of tables contain look-ups to other tables. For example, if a person belongs to an Association then there is a look up to the name of that Association from a related table. Straightforward stuff. Works beautifully on my development server.
My problem arises when I transfer everything to the remote production server. Database installs ok. Membership system works ok. Pages work ok. But lookups don't work. The drop-down box simply says "Searching..." and the little spinning wheel keeps spinning.
Obviously something isn't reading something else or can't find it. Maybe an index problem?? Probably that human causing it!
I have checked everything I can think of and besides it works well internally. So what might the cause be? Perhaps someone here has come across a similar problem.
Thanks in anticipation.
I have created a simple database with Appgini where a number of tables contain look-ups to other tables. For example, if a person belongs to an Association then there is a look up to the name of that Association from a related table. Straightforward stuff. Works beautifully on my development server.
My problem arises when I transfer everything to the remote production server. Database installs ok. Membership system works ok. Pages work ok. But lookups don't work. The drop-down box simply says "Searching..." and the little spinning wheel keeps spinning.
Obviously something isn't reading something else or can't find it. Maybe an index problem?? Probably that human causing it!
I have checked everything I can think of and besides it works well internally. So what might the cause be? Perhaps someone here has come across a similar problem.
Thanks in anticipation.