saving data from a single form to different table

[Bismi]

Hi guys,
The function of the sytem to just enter some details about a request and
find out its score with some crietia ,find the total score and report it
according to score. Each criteria has a descritpion ,its user score and its
panel score. We will take the highest score for calculation.
Each reqeust has 4 different crieteria .
The existing system has a big table having all information in it . no
normalisation is done. I am trying to normalise that..
But I don’t know how to link the tables to get saved the information from a
single form.

 

[Steve Schapel]

Bismi,

I must admit I haven't got a clear picture of your project as yet. But
if you mean that there are, in reality, some one-to-many relationships
within your actual data, and that you are re-designing your tables to
reflect this reality, then I would suspect that the form design will
also need modifying. One of the standard ways for forms to reflect a
one-to-many relationship is by the use of a main form for the "one" side
data, with a subform for the "many" side data.