Updating a table via a combo box...

[skirkybaby]

Ok, please bear with me as I have managed to make this problem more complicated than it is.. and my database / relationship design is quite possibly awful.

Here goes -

Basically I have a database i've created for "Testing" software. It has a form with one subform and one datasheet subform associated with it.

The main form allows a tester to chooose an application, the subform then show's details of what tests are required, which works fine. There are 4 types of test : Client/Server, Client, Web and Other - This is set in a combo box they choose from the sub form.

Because of the relationship, for each type of the 4 tests, there is a seperate subform of test data (the datasheet).

This is comprised of the following visible fields:

Test Step; Pass or Fail; Comments; Tester Initials

As a tester completes a step, they start a new record, untill the test is complete. Once complete they can then choose a new test type and do the next set of tests, once all the tests are complete, they can choose a new application from the main form and continue all over etc.

The problem im having is I want some way of auto-filling in the test step based on the choice of test type chosen.

I.e If the user chooses Client/Server as the test.,

I want the first two records (steps) to show: 1) Does it install?
2) Does it connect?

To make sure there is some kind of conformity to the results the tester types in. Is there an easy way of linking this? What fields/relationships between the tables for tests and tables for "sub tests" (steps) as ive called it will I need.

Any help would be appreciated, I can supply screenshots etc if needed!

Kind Regards,

Simon

 

[Nick-in-Paris]

Solution

I think I can help you if you can tell me how to create snapshots of my dbase to post, I think I have one that does a similar thing. I will also need to know how to snapshot in design mode.

 

[skirkybaby]

Hi Nick,

Snapshots as in screenshots? If so I would just push Print Screen sometimes marked as (Prnt Scrn) on the keyboard, paste that into paint, save it as a JPG and upload it.

Kind Regards,

Simon

 

[Nick-in-Paris]

Personnel form

What this does is you select a persons record (naviagation with form buttons),
The subform shows timesheets for that person only
and the data sheet in the subform shows their details on the project.

You can modify personnel, timesheets and timesheet details - and all this backs up to the main tables.

Is the logic of this something like what you are looking for ? If so, I'll give you more information on the structure.

 

[skirkybaby]

Hi Again Nick,

Thats similair yes, although I am already at the same stage as that really.. I've attached some screenshots to clearer illustrate my point.

Basically when the red circled item is changed to one of the 4 options previously mentioned:

<quote>
There are 4 types of test : Client/Server, Client, Web and Other - This is set in a combo box they choose from the sub form.
</quote>

I want the first two records of the sub form filled in automatically (where the arrows point to).

Ive attached a screenshot of the form with data ive manually entered to show you. And also a shot of the database.

Cheers,

Simon

 

[Nick-in-Paris]

I may have the solution

But it involves creating queries that go back to tables. I'm at work at the moment, but I'll have a look at it tonight - if you haven't already found the answer by then!

Speak to you soon

 

[Nick-in-Paris]

Link Table

I think I know what you need:

Each application can have many tests associated with it: correct?
and
Each test can relate to many applications: correct?

You need to form a table called a many to many relationship (and keep it in a table.
I would suggest create a tale that looks up applications and looks up Tests.

Then either in a table or query Take your application table, add in subdata sheet Appl/Test, and that should give you the tests relative to each application. You then simply need to add in another sub data to test which shows the results of those tests.

That should work - oh yeah, and then auto form it.

Let me know how you get on

 

[Nick-in-Paris]

This works for me

Have a look at the very simplistic followig immages

 

[Nick-in-Paris]

Did that help you

Simon, did you get around the problem?