I had an Access database and I had always used in my tables (whenever
possible) pop up lists to choose elements.. for example, for a column
I've wrote in "Datensatzherku nft" SELECT tbl.field1 FROM tbl WHERE
tbl.field2 LIKE 'XXX'; or I could say that only certain values are
allowed: "X";"O";"S" as an example.
Now I have exported my Access Database to MySql and established from
Access a relation to MySQL so that I can update the database direct
from Access and no from PHPMyAdmin.
The problem is that these information about "where to whole the data
from.." that's to say the "Select tbl.field1...." where not exported
and in PHPMyAdmin I cannot find where I can define such attributes. If
I try to do it from Access I receive I message saying that I cannot
change the properties of the database since it is a linked
(verknüpfte) table. Any idea how can I "export these properties too or
redefine them in PHPMyAdmin?
possible) pop up lists to choose elements.. for example, for a column
I've wrote in "Datensatzherku nft" SELECT tbl.field1 FROM tbl WHERE
tbl.field2 LIKE 'XXX'; or I could say that only certain values are
allowed: "X";"O";"S" as an example.
Now I have exported my Access Database to MySql and established from
Access a relation to MySQL so that I can update the database direct
from Access and no from PHPMyAdmin.
The problem is that these information about "where to whole the data
from.." that's to say the "Select tbl.field1...." where not exported
and in PHPMyAdmin I cannot find where I can define such attributes. If
I try to do it from Access I receive I message saying that I cannot
change the properties of the database since it is a linked
(verknüpfte) table. Any idea how can I "export these properties too or
redefine them in PHPMyAdmin?