I have a query based on 2 tables. Emptbl, Availtbl. They are related by EmpNo field. When the empno is typed the name field fills in. <br><br>I need to get all the records for certain fields to export to a text file. Join type 2 gives me the records but does not populate the empno field for all the records. <br><br>What can I do to get all the fields I've queried, for all the records. Thanks you for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Field not populated
- Thread starter cav
- Start date
Sorry, can't figure out what you're talking about.
<I have a query based on 2 tables. Emptbl, Availtbl. They are related by EmpNo field.> Do you mean you have set up a relationship with referential integrity between the two tables on the EmpNo field, with Emptbl as the parent? If not please specify.
<When the empno is typed the name field fills in.> Don't understand what this has to do wtih the problem. Do you mean that the EmpNo field is set up as a lookup that displays Employee name in table design, or are you talking about something having to do with a separate form or query?
<I need to get all the records for certain fields to export to a text file. Join type 2 gives me the records but does not populate the empno field for all the records.> In a query? In the table? In a form?
Try to make this easy on us by giving more detail ... and paste your SQL statement here too.
<I have a query based on 2 tables. Emptbl, Availtbl. They are related by EmpNo field.> Do you mean you have set up a relationship with referential integrity between the two tables on the EmpNo field, with Emptbl as the parent? If not please specify.
<When the empno is typed the name field fills in.> Don't understand what this has to do wtih the problem. Do you mean that the EmpNo field is set up as a lookup that displays Employee name in table design, or are you talking about something having to do with a separate form or query?
<I need to get all the records for certain fields to export to a text file. Join type 2 gives me the records but does not populate the empno field for all the records.> In a query? In the table? In a form?
Try to make this easy on us by giving more detail ... and paste your SQL statement here too.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question