Hi
I have a table called Billing which works fine
I add a new look-up field on the desktop by modifying the .axp file, make a new folder and upload the folder to the server
I notice that the Billing table on the server goes blank. I cannot see any fields,
I have looked in PHP my admin and I can see the intact table and fields
Any advise would help
Thanks
Sam
Table content dissapears when adding new Lookup field
Re: Table content dissapears when adding new Lookup field
Hi,
can you try to recreate your fields through the admin area
can you try to recreate your fields through the admin area
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Table content dissapears when adding new Lookup field
First of all thank you for even replyinig
I am struggling with this for past few days
I went to admin in rebuild fields
No deviations found. All fields OK!
I am struggling with this for past few days
I went to admin in rebuild fields
No deviations found. All fields OK!
Re: Table content dissapears when adding new Lookup field
Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookuptables it shuts down
Thanks
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookuptables it shuts down
Thanks
Re: Table content dissapears when adding new Lookup field
Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookupfields it shuts down
Thanks
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookupfields it shuts down
Thanks