Link to home
Start Free TrialLog in
Avatar of verpit
verpitFlag for United States of America

asked on

existing form to new table

I ran into a problem when putting the final touches on my database which resulted in a new table design at the recommendation of EE experts.  Now I need to link the two back up.

I need to link the Main frmTasks in the old database to the New tables in the new database, both of which can be found here at www.dropio.com/tasksdb.

PURPOSE OF DATABASE:
1. Record start and stop times of individual tasks (up-to several Xs daily for each).
2. Keep various categories of tasks.
3. Provide detail associated with the following three (3) items.
 - day
 - task
 - stated activity
Avatar of calpurnia
calpurnia
Flag of United Kingdom of Great Britain and Northern Ireland image

I can't see a form called frmTasks in the old database...
Avatar of verpit

ASKER

sorry, it was called frmAddTask :(

I really appreciate your help cal,   any progress will be accepted immediately and a new question posted.
Looks to me like the first thing you need to do is create a query which will pull out the most recent activity for each task. Would that be based on the value of fldStarted?
Avatar of verpit

ASKER

I don't know :(
OK, let me rephrase the question. If you look at tblActivity, how can you tell which is the most recent activity for a given task?
Avatar of verpit

ASKER

The tables are the work of sb9 at the end of this related thread.  It is his design.  I was trying to get a good descriptions of each field before he left but was unable to.  According to tblActivity, it does look like fldStarted would give you the most recent activity for a given task.  That certainly seems logical.  You can see a text file of each field also at www.dropio.com/tasksdb.  Thanks again for your effort.
verpit, even if someone else designed the tables, it's your data and it's vital that you have a clear understanding of what each field means before you do any further development work on your database.
Avatar of verpit

ASKER

I completely agree and have pasted your message into the original thread here re-requesting that information from SB9.  Since he designed them, It is clearly him that would have the greatest capacity in this department.
ASKER CERTIFIED SOLUTION
Avatar of Sheils
Sheils
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of verpit

ASKER

Thanks Sb9.  It would be helpful to have definitions of each field clearly noted in a text file like the one at www.dropio.com/tasksdb.

If you could add that before you go away, it would be very helpful indeed.  I will then accept and post a follow-up question.  Again, let me say "fine work" and and a sincere thank you for the current table design!  
Avatar of verpit

ASKER

my plan was to modify the query sql without changing the name of itscolunm, so that it  can retrient and insert data into the table. By notchanging the name of the column you should be able to have the formalmost imediately

can you name them?
Avatar of verpit

ASKER

Queries and forms I really do intend to read but won't have time for a while.  I was actually hoping to get this up first with that as my next step.  Currently, I don't even have time for the collaborative effort from the fellow at crossloop.  I could hire someone from rentacoder but then I would have even less of a hand in it because I would have to turn it over.  Believe me that I do want to go over the material and understand it and I think you are right.  I have been paying attention to the extent that I have the time.  In the zip of your training materials, you are speaking of item #6, correct?
Avatar of verpit

ASKER

sb9 - are are you still with me?
Avatar of verpit

ASKER

sb9..  Your migration plan (paraphrased from post ID#22860639) along with an updated database has been posted at www.dropio.com/tasksdb.  Do you think you could make the modifications?  The original query and form have been imported into it.