index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Master Details not working :: (2)Post a New Message | Post a Reply
Apr 15 2005, 10:25 AM
 Master Details not workingPost a Reply
 vdevigere

View this author's profile Send this author a private message Visit author's homepage

since: Apr 1, 2005
from: college station

There seems to be a problem with the master details setup. I have two tables: supervisor, employee. The fields are as follows
supervisor : sid, firstname, lastname, email
employee: eid, sid, firstname, lastname, email
I have just two supervisors and 3 employees

When I make the supervisor table as the master table, It shows only one of the supervisors, however when I sort it by the supervisors by the first name, everything works fine.
With a more elaborate real-life setup with programs and students, (master table= programs) it shows duplicate programs and students are missing. However sorting it fixes all problems

Viddu

Apr 17 2005, 8:56 AM
 Re: Master Details not workingPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Re-order the fields with the supervisor name as the first column then check the Set as default sort order checkbox found on the Re-Order your table fields screen.




-------------------------
Ghost
Pages: (1)   [1]

search this forum: