ckroon
Posts: 869
|
| Posted: 11/03/2006, 1:16 PM |
|
I have a grid based on a table and I want to display the grid along with fields from two other tables.
The main table is 'tb2' with these fields: barcode, isbn and student_id.
I want to display these three fields plus the name of the student (from the 'students' table) and the title of the book (from the 'isbn' table)
When I build the relationship in the QB, with 'tb2' and 'students', it works great. As soon as I add the next table, it stops displaying records. And vice versa. If I use 'tb2' and 'isbn', no problems, add the 'students' table, no records display.
Where should I look for the problem?
_________________
Walter Kempees...you are dearly missed. |
 |
 |
wkempees
Posts: 1679
|
| Posted: 11/04/2006, 5:41 AM |
|
PM read and replied.
What your are attempting in VQB is feasable, so it must be that you are doing something wrong.
First:
In VQB, are you in TABLE or SQL mode (top Left)
In Table Mode, you should have the three tables in the upper right Pane.
Tick (check) the fields from each table that you need.
Also there should be relationship lines from one table to the other.
clicking these enables you to edit the relationship.
these should be:
from tb2 to student on student_id =
from tb2 to books on isbn =
the Where clause is probably already offered, just check it.
The in VQB press the View Data and see what it brings.
Empty data sets could also be caused by the where parameters in the VQB being set by a previous run.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
