Form Construction Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm having a problem getting my head round one of my forms.

The business model is a call accreditation session (Where the team leader
sits down with recordings of customer services calls, and gives people points
based on certain criteria)

I have these tables related to this process:

Calls (Time, Date, Customer, Member of Staff making the call)
Sessions (Call ID, Staff ID, Criteria ID, Response)

So what I am doing is storing data about the calls in a different table, and
using the ID number of that call in the Sessions table to uniquely identify
the call.

What I can't figure out is how will I get people to enter this data via a
form? There is about 32 questions and they are all stored in another
database! It's a question per record, so the call ID, Staff name etc are all
reentered for the next record until all 32 questions have been completed...
Is there an easier way of doing this or am I going to have to copy the data
to each record until the session is finished?

Cheers

Toby
 
Try running your data entry form off a query where the two tables are linked
by CallID. Be sure to put all fields needed for data entry in the query.
When you say the questions are stored in a different database do you actually
mean a separate .mdb or a different table? If it is in a separate database,
then you can link the table to your database. If you don't already have the
database you are working on with the data split, you would need to consider
doing that also.

Hope this helps.
 
Hi Jackie, thanks for your help.

It's a seperate table, sorry.

There are about 30 questions for each campaign, and I'm having trouble
trying to figure out how to display all 30? I know access can do it one
record at a time but I can't get my head round it!

Cheers

Toby
 
Thanks Jackie,

I know what you mean, but when I have say, 32 questions that have to be
completed for a candidate, how do I go about displaying all 32 questions on
the form at once?

Regards,

Toby
 
Make sure your form is set to continuous. Otherwise, if you want the
questions to be a choice for one field, you can use a combobox.
 
Back
Top