G
Guest
Greeting all. I searched past questions before posting again, but what I
found that might help me was over my head. I have separated my one large
table into many small tables, all pertaining to telecom fiber jobs. I have
made a form on which there are fields from multiple tables. The control
source for the form is set to my table 'tblJobInfo', on which I have general
information about each job. On the form, however, there are fields from
other tables with more specific information about each job, such as fiber
types and footages. If I have field '144FiberFootage' on my form, from
'tbl144Fiber', how do I get the form to show the information from the other
table. On the form I have set the control for that field to be
'tbl144Fiber', but it still shows only '#Name?'. How do I make this work?
Is this something that a newbie can accomplish? Everyone here has been so
helpful during my struggle with this. I think you all have put me on the
right track, and I thank all of you so much.
Greg Snidow
found that might help me was over my head. I have separated my one large
table into many small tables, all pertaining to telecom fiber jobs. I have
made a form on which there are fields from multiple tables. The control
source for the form is set to my table 'tblJobInfo', on which I have general
information about each job. On the form, however, there are fields from
other tables with more specific information about each job, such as fiber
types and footages. If I have field '144FiberFootage' on my form, from
'tbl144Fiber', how do I get the form to show the information from the other
table. On the form I have set the control for that field to be
'tbl144Fiber', but it still shows only '#Name?'. How do I make this work?
Is this something that a newbie can accomplish? Everyone here has been so
helpful during my struggle with this. I think you all have put me on the
right track, and I thank all of you so much.
Greg Snidow