I have various applications running locally from a variety of databases, all in MYSQL.
most of the applications need a login for the staff and a lookup for the pupils names, so I have tried to keep all the applications running from one set of tables.
Now comes the time where I need to write a separate application with a seperate database but use the staff and pupil data. I want this to reduce maintenance work each time we gain or lose staff and/or pupils.
I have found that I can pull information from tables in another database via queries, as long as I form the innerjoin in the SQL tab of phpr and use the "`database`.`table`.`field`" format.
BUT, I need to create a lookup from a table in an external database and I cannot see a way of doing this. I am thinking along the lines of creating a view in phpr pointing to the external table, but I cannot see where in the saved project file I need to hack to make it work, can anyone help please, either officially or unofficially?
TIA