hey, here is my setup
i have a GENERAL table with medical patients basic information.
then i have multiple other tables (medications, visits, diagnosis, referring doctors), all linked by HistNum.
i have a form that opens a report filtered to a single patient and is going to display all of these tables. there is the main information on top, and then a subreport for the reffering doctor (this is all i have so far)
in the subreports properties, i have the Master/Child links set correctly by HistNum but nothing appears.. however, if i change it to ID, which is an irrelevant field in both tables, information does appear..
also, in an earlier thread where i ask about how to eliminate the whitespace left behind from cells of the table that are missing, i was told to "set the height of the controls to a negligible height and the can grow to yes", then the missing lines should be eliminated. for this, do all my fields i want displayed have to be part of 1 big text box, or multiple? (right now i use multiple)
what does this person mean by a negligible height?
heres a screenshot of the report
i have a GENERAL table with medical patients basic information.
then i have multiple other tables (medications, visits, diagnosis, referring doctors), all linked by HistNum.
i have a form that opens a report filtered to a single patient and is going to display all of these tables. there is the main information on top, and then a subreport for the reffering doctor (this is all i have so far)
in the subreports properties, i have the Master/Child links set correctly by HistNum but nothing appears.. however, if i change it to ID, which is an irrelevant field in both tables, information does appear..
also, in an earlier thread where i ask about how to eliminate the whitespace left behind from cells of the table that are missing, i was told to "set the height of the controls to a negligible height and the can grow to yes", then the missing lines should be eliminated. for this, do all my fields i want displayed have to be part of 1 big text box, or multiple? (right now i use multiple)
what does this person mean by a negligible height?
heres a screenshot of the report