Dr.Bob
|
| Posted: 07/19/2002, 2:56 PM |
|
Hi all,
I have a MySQL db with a couple of tables that are linked together, like the table 'Project' has a field 'ProducerID' that's linked with the table 'Producer' (ofcourse 
I managed to get a list box in the _maint-view with the names (producer.name) that come with the field producer.id. But what I want also is to get these names from that other table in the list view of the first table. See what I mean? Cause now I only get the actual inserted 'id' field in this view, and not the name-field-value that's linked with it.
I hope someone can help me, as this is a very important option for me, and helpes me to make a decision whether to buy the software or not (am testing the trial now).
Thanx!
|
|
|
 |
Dr.Bob
|
| Posted: 07/19/2002, 3:54 PM |
|
Never mind, I found it (even though it seems a bit too complicated to me when I follow the directions from the tutorial pages 17-27)
Oh, and I do get an error building the query:[MySQL][ODBC 3.51 Driver][mysqld-3.23.39-nt] bla bla bla SQL syntax error bla bla bla ...
But the thing is, that the final result = 100% OK, so I'm wondering why he tells me there's an error ...
|
|
|
|
|
