Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Moving Sub-Jobs to other Jobs |
Author |
Message |
|
Posted : 2007-04-16 23:35:58 |
I have organized the customer hieracrchy as follows:
- Customer
- Job
- Task
A job has multiple Tasks that are unique to the customer, and may repeat Job to Job. Once a Job is complete, we move all Tasks in that Job to a Job for that customer called Complete. When a new Job is added for that customer, our first action is to move repeating tasks from Complete to the new Job.
The Table Detail Reference tell me ParentListRefID and corresponding fields cannot be modified. How can I use an Access routine to move these Tasks among Jobs. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-17 08:30:37 |
As the customer (ParentListRefID) is always the same, you would normally change (update) the transactions from one customer:job CustomerRefListID to the other customer:job CustomerRefListID
Each job or task has its own CustomerRefListID. See: Adding Customer - Job |
|
|
|
|
Posted : 2007-04-19 04:27:50 |
Using the VBDemo utility, I was able to successfully move a task at sublevel 2 for a customer from one job at sublevel 1 to a different job at sublevel 1, using the ParentRefFullName field.
The QB data base immediately reflected the change...the VBDemo query executed immediately after the update did not. I understand this to be a Sync issue, so I will have to do a resync after executing this command, which may be many times in one day. What sync option do you recommend rather than resync'g the entire file each time I execute my routine? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-19 10:49:41 |
|
|
|
|