phpmyadmin

[dolodolo]

Hi there,

I'm creating a very simple database in phpmyadmin. How do I assign a possible value list to a field in a table? The PV list is an indexed field in a different table.

I can't figure out how to do it in phpmyadmin.

Thanks for your help.
Dolores

 

[r937]

possible value list?

since you mentioned a second table, are you thinking of creating a foreign key?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[dolodolo]

Yes, I should create a foreign key but I don't see anywhere to do that on phpmyadmin.

 

[r937]

try heidisql instead

it's a ~much~ nicer user interface



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[dolodolo]

It's not my website - thanks anyway. I'll just execute code.