Automated Field Data

[ootkhopdi]

Hi

i have a table name "FinalData"
in this table i have Seven fields , "EmpName", "EmpID" , "Post","PAN","Account" , "PAY_NO", PAY_Code"
"Pay_No" and "Pay_Code" Depends on Other Fields like EMPID and PAN
"Pay_No" = Count of Empid before this record
"Pay_Code"= "Empid"&"/"& "Pay_No"
i want to fill , Pay_No and Pay_Code without any other table

how can i find it in field as i create a new record

please help me

i want to fill a field in my table which is depend on its other fields

 

[moke123]

the short answer is you create a calculated field which concatenates the two fields you are combining.

however...
you shouldnt need to store this data as you can create it on the fly in a query.

 

[ootkhopdi]

thanks
but how can get Pay_No in one field,,
when i got it by query , query run very slow,

 

[jdraw]

Show us your table structures, and the SQL for the query.

 

[ootkhopdi]

find table and qry

my original data having records more than 100000..
when i set default value for field Pay_No as query it shows error massage like screen shot attached..

please help me

 

[ootkhopdi]

Please help me
now i am doing it following steps
first create a table named "Pay_no" with query "qryPay_No"
then secondly Create other table "PAY_CODE" containing "PAY_CODE" with "qryPaycode" for concatenate two fields
then finally get results within desired table"Final" with Dlookup

but this is a lengthy and time taken process
and i don't know how use temporary query and temporary tables for result

please give me solution for removing these steps for time saving and fast processing.
thanks in advance...