richard luft
Registered User.
- Local time
- Today, 08:57
- Joined
- Jun 4, 2004
- Messages
- 63
I'm having a problem appending some records from one table to another, and hope that someone can get me on the right track. I'm trying to append a small group of records-perhaps five at a time, from tbltemp to tblservices. Each line in tblServices must have an entry 'LineNumber', which is assigned from calling Next_Custom_Counter_LineNum(). Other entries which must be manually entered are 'Date_of_svc' and 'EntryNum'.
I've tried using an append query to do this, but this has not worked for more than one record transfer, due to the function call: (due to 'key violations')
Selrct-------,[Forms]!Form1![EntryNum] AS EntryNum, [EnterDate:mm-dd-yyyy] AS Date_of_Svc,"
'MySQL = MySQL & " Next_Custom_Counter_LineNum() as LineNum"
I've also tried using coding to do this, but I can't seem to get the right approach----at all!
Any help would be appreciated
Rich
I've tried using an append query to do this, but this has not worked for more than one record transfer, due to the function call: (due to 'key violations')
Selrct-------,[Forms]!Form1![EntryNum] AS EntryNum, [EnterDate:mm-dd-yyyy] AS Date_of_Svc,"
'MySQL = MySQL & " Next_Custom_Counter_LineNum() as LineNum"
I've also tried using coding to do this, but I can't seem to get the right approach----at all!
Any help would be appreciated
Rich
Last edited:
