Re: Swap data in multiple fields between 2 records

Hi Rob,

Thanks for the help. I understand now the basic concept to swap details
between 2 records as long as their tables are related.

However, as u suggested - after I insert the new 'PersonID' inorder to
replace the the existing candidate - should I then press 'refresh data' and
will the details of the replaced candidate be swapped with the shifted
candidate without entering the personID at the other end .

I hope it makes sense.

"Rob Parker" wrote:

If you're designing your database correctly, there should be no problem with
this, because the details for each person will be in a separate table from
the details of people attending courses. That table will only contain a
single field (eg. PersonID) identifying the person attending the course, and
when you change that to the PersonID from the table containing all people,
everything else automatically follows. If that's not what's happening, then
I strongly suggest that you go and do some reading on relational databases
and table normalisation, because you've got it wrong, and you need to
redesign your database structure. This should help:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

In particular, follow the links to articles about database normalization.

HTH,

Rob


"Agnelo Fernandes" <Agnelo Fernandes@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:2A92D3C0-9B7D-4BEA-B9AE-66D800474242@xxxxxxxxxxxxxxxx
I am designing a database for candidates attending a course in a given
year.
The list of candidates coming on given day is prefixed. Say for a
partiular
course 'Foundation Course' a person X scheduled to attend on 21st March is
swapping with a person Y who was schedules on 30th march.
Information of person X (such as his college, contact details, etc) is on
record A and information of person Y is on record B.

I need to swap X and Y with all their details (i.e fields) between the 2
records.
Can anyone help me?




.

Relevant Pages

  • Re: Swap data in multiple fields between 2 records
    ... I understand now the basic concept to swap details ... as u suggested - after I insert the new 'PersonID' inorder to ... then go and read some more about related tables and data normalisation. ... follow the links to articles about database normalization. ...
    (microsoft.public.access.formscoding)
  • Re: Swap data in multiple fields between 2 records
    ... when you change that to the PersonID from the table containing all people, ... redesign your database structure. ... follow the links to articles about database normalization. ... swapping with a person Y who was schedules on 30th march. ...
    (microsoft.public.access.formscoding)
  • Re: Controlling Data Formatting
    ... But the fact that you've hit this snag means that your database ... PersonID ... a record in tblPersonsTrainingItems like this: ... >does not require certain training items. ...
    (microsoft.public.access.gettingstarted)
  • Re: Editing Union results
    ... UNION queries are never updateable and cannot be made ... 8i+, SQL Server 7.0+, etc., by using "INSTEAD OF" triggers on views made ... the data from the form back into another function back into the database. ... personID ...
    (microsoft.public.access.queries)
  • data bound combobox does not leave focus
    ... Visual Studio with ADO.NET for the first time (Borland ... I have two test tables in a JET database. ... control type for PersonID to ComboBox in the DataSource ... Combobox to the generated personsBindingSource, ...
    (microsoft.public.dotnet.framework.adonet)
Loading