N
NES
I have a primary form whose data source is a "Master Table Query" which
contains 4 tables all properly linked I believe.
I have a sub form whose data source is a "Detail Table" which is not
included in the above mentioned query. On the occasions that I have tried to
include it, I get SQL error problems.
The sub form seems to be following the main form records ok. but even though
the Master Table Query and the Detail Table share common names, field types
and sizes, they do not share that. The record number from the Master is
appearing in the Detail table, but other information is missing.
Now... I understand that when looking at the data tab in the sub form (at
least when in design view) should be showing Master and Child links. In fact,
no such links occur, or even have a PLACE to appear. It's like the sub form
isn't linked.
Please tell me what I'm doing wrong. Many many thanks for some help with
this. I have spent about a week trying to figure this out.
contains 4 tables all properly linked I believe.
I have a sub form whose data source is a "Detail Table" which is not
included in the above mentioned query. On the occasions that I have tried to
include it, I get SQL error problems.
The sub form seems to be following the main form records ok. but even though
the Master Table Query and the Detail Table share common names, field types
and sizes, they do not share that. The record number from the Master is
appearing in the Detail table, but other information is missing.
Now... I understand that when looking at the data tab in the sub form (at
least when in design view) should be showing Master and Child links. In fact,
no such links occur, or even have a PLACE to appear. It's like the sub form
isn't linked.
Please tell me what I'm doing wrong. Many many thanks for some help with
this. I have spent about a week trying to figure this out.