Table auto update from relationship

[georg0307]

Dear All,

Could you please help me understanding, what I am doing wrong in the attached Acces.

I'd like to create relationship, so when I put a new record and the title of the Course "TITOLO" automatically fill the other related fields "ISTRUTTORE", "DESCRIZIONE".

I can do it with a query in the Mask but the original Table doesn't contain the data of the new record.

Thanks in advance.

Sorry if not clear.

 

[Eugene-LS]

Could you please help me understanding, what I am doing wrong in the attached Acces.

You've done a lot wrong
1. Relationship between tables by text fields
2. Duplication of the same data (and a long text)
3. Text key fields in tables
I think I understand what you want – if you wait a bit, I will fix everything and show you the solution

 

[theDBguy]

That's the beauty of relationships. All you need to store is the ID of the parent table as a foreign key in the child table.

 

[Eugene-LS]

Could you please help me understanding, what I am doing wrong in the attached Acces.

Here you are:

 

[mike60smart]

Hi George

Eugene has created 1 Form to manage all 3 relationships by using a query as the Record Source.

This is the wrong way to do this.

Your table design is 3 tables with the Main table "Dipendenti" having a Relationship with table "Agenda_Corsi"

In the attached I created a Main Form to all ow you to select a Person
With a Subform to allow you to select the Courses that are related.

 

[georg0307]

Ciao,
many thanks, I will study bettter how relathionships in access works. I will go on using your suggestion

 

[Eugene-LS]

Eugene has created 1 Form to manage all 3 relationships by using a query as the Record Source.
This is the wrong way to do this

And aren't you ashamed to write this?
In fact, I completely rebuilt the database (normalized it as it should be), and the form is not mine, but TC - I just corrected it a little.
Please be more attentive.

 

[mike60smart]

And aren't you ashamed to write this?
In fact, I completely rebuilt the database (normalized it as it should be), and the form is not mine, but TC - I just corrected it a little.
Please be more attentive.

My apologies

I did not look at the original database and assumed quite wrongly that you had produced the Form.

All I did, in addition to you changing the Relationships so that they would work, was to produce a Main Form & Subform

Again my apololies

 

[Eugene-LS]

Again my apololies

Got it!
The Flame Over.