One to many relationship

[DevAccess]

Hello

I am creating a resume builder database, below is attached work I have done till date

What I want is given resume ID (one) and name I want to add educations(many) and certifications(many) to be entered in tab table.

When I create a new record for resume and add educations and certifications it does not appear in datasheet view in education and in certifications tab.

Please advice what is missing here.
Note: For creating a new record goto frm_mainmenu and click on create a new record to start with.
I may have more tables to be added in same fashion.

 

[Uncle Gizmo]

There's another thread running from the same OP in a similar vein. I'm pointing this out because I think there is the danger of the same question being answered twice in different threads.

Sent from my SM-G925F using Tapatalk

 

[jdraw]

I agree with Uncle G, this seems to be part of an ongoing thread.

DevAccess,

Can these posts/threads be combined??


I recommend you do NOT use embedded spaces in your field or object names. Embedded spaces will cause you syntax issues at some time.

Also, I would suggest you consider explicit reference tables for Education and Certifications. Such tables would not have an AchievedOn field. It would be an association/ link/junction table that would identify the Person/Resume and the specifics of that Person's Education and Achievements including the AchievedOnDate etc. Achieved on is specific to the Person, not the Education (or Achievement) per se.

 

[missinglinq]

When I create a new record for resume and add educations and certifications it does not appear in datasheet view in education and in certifications tab.

Can you explain this a little more clearly? Especially the "in datasheet view in education and in certifications tab."

The only problem I found, after entering a new resume and then opening all other Forms was with frmRecordDisplayer. The appropriate data didn't show in this Form because the Query you're using as a Record Source, for the Form, doesn't contain the Fields you're using as Control Sources for your Controls...you've simply entered names (including Name, which is a Reserved Word and should never be used as the actual name of an Object, Field, or Control) in the Control Sources!

Linq ;0)>

 

[static]

Add the ResumeID field to qry_Certifications.
On the 'Certifications & Security' tab set link master and link child properties to ResumeID

 

[DevAccess]

Add the ResumeID field to qry_Certifications.
On the 'Certifications & Security' tab set link master and link child properties to ResumeID

How does this happens, resume ID and qry_certifications would populate automatically.?

 

[DevAccess]

Can you explain this a little more clearly? Especially the "in datasheet view in education and in certifications tab."

The only problem I found, after entering a new resume and then opening all other Forms was with frmRecordDisplayer. The appropriate data didn't show in this Form because the Query you're using as a Record Source, for the Form, doesn't contain the Fields you're using as Control Sources for your Controls...you've simply entered names (including Name, which is a Reserved Word and should never be used as the actual name of an Object, Field, or Control) in the Control Sources!

Linq ;0)>

Thanks Missingling, but frmRecordDisplayer is secondory form and that needs to be fixed, can you please help me creating a seperate database wherein One resume ID & Name can have multiple educations records, I want to see what I am missing here, thanks for your help.

 

[static]

How does this happens, resume ID and qry_certifications would populate automatically.?

Yes. A child linked to a master is filtered by the master and new child records have the linked fields populated automatically.

 

[DevAccess]

Yes. A child linked to a master is filtered by the master and new child records have the linked fields populated automatically.

No it is not working, I mean it is not populating related records in it, could you please create sample database and send it to me ? Just for two tab table one for resume ID and name and one for Education.