Field not populated
Field not populated
(OP)
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.
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.
What can I do to get all the fields I've queried, for all the records. Thanks you for your help.
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.
What can I do to get all the fields I've queried, for all the records. Thanks you for your help.
Talk To Other Members
RE: Field not populated
<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.