timesheet revisited

[Guest]

Hi ya'll...

I am dire need of some clear thinking. Here is the situation....

I am running split databases... the timesheets are entities that are
controlled by the employee. I have control of the project information. I need
to allow the employee to view the project number, project name, client name,
and project manager from my database. That information will need to be
appended to the timesheet so they don't have to retype the information (has
to do with errors in the final summary). At the same time, they will need to
input date, hours, task code, and work description for that job. (the reason
for split databases is due to the frequency of travel and having to port
their timesheet database via laptop to the jobsite.)

So currently I have two databases

1 Corporate_Jobs > (table) Proj_Info > (fields) Job Number, Job Name, Client
Name, Project Manager, Job Status, etc...

2. Timesheet > (table) Time > (fields) Job Number, Job Name, Client Name,
Project Manager, Date, Hours, Task code, Work Description.

Now, what I am trying to do is parse information from the Corporate Jobs
database and insert it into the Timesheet database (yeah, I have already
tried to explain this a couple of times, but the boss says he wants the
information separate, period). I have created a form that has the Job Number,
Job Name, Client Name, and PM - I am able to scroll through the information,
but not having any luck taking the information from the form and adding it to
the time table. I would also like to have the capability to have a complete
entry form that will allow me to have a command button that will append the
information to the time table.

If I am way out of line here, I'd sure like to have some suggestions on how
to rethink what I am trying to accomplish. a simple timesheet that has a job
lookup and ability to drop the correct information into the time table.

 

[Guest]

Allan,

Both databases (Service Call and Time & Billing) are using subforms to
capture data. This is great up to a point, but neither will allow me to do
what I am trying to do: Move information from the split database, into an
individual table.. I need the information from the (linked) proj_info table
that has been selected, which is currently attached as subform and place it
into the Timesheet database into the time table.

I know this is not the best solution, but it's the one that will work for
the exercise.

tia

 

[Allan Murphy]

Bob

Replay to me off list as I may have a solution