SUPP_CODE would go to the ACCNT_CODE in the the relevant tblSundatabaseXXX along with NAMOUNT which would link to AMOUNT in the relevant tblSundatabaseXXX and JRNAL_REF as 2 and WHERE the READY field is yes. I would copy the first records in the following way:ĪCCNT_CODE would go to the ACCNT_CODE in the the relevant tblSundatabaseXXX along with GAMOUNT which would link to AMOUNT in the relevant tblSundatabaseXXX and JRNAL_REF as 1 and WHERE the READY field is yes. So in the first example I would first copy to tblSunDatabaseABC and for the second records I would copy to tblSunDatabaseCDE.Ģ. XXX is the field value from the above records. ![]() Insert into another table which is based on tblSundatabaseXXX. SUN_DB ACCNT_CODE SUPP_CODE NAMOUNT GAMOUNT VAT JRNAL_REF JRNAL_LINE READYġ. ![]() ![]() ![]() My data is stored in "tblTest" as follows:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |