Resume Builder database questions (1 Viewer)

DevAccess

Registered User.
Local time
Today, 13:16
Joined
Jun 27, 2016
Messages
321
Hello there

I am developing a resume builder database wherein HR would enter data for employee into the form and then they can generate a resumes in the PDFs or word documents.

Attached is the relationship diagram and one resume ID can have N number of Educations/Experiences/Current positions/Certifications, therefore one to many relationship.

Please refer problem in screenshot attached.
 

Attachments

  • Screen1.png
    Screen1.png
    11.5 KB · Views: 111
  • Relationship.png
    Relationship.png
    25.3 KB · Views: 110
  • Screen2.png
    Screen2.png
    26.2 KB · Views: 118

isladogs

MVP / VIP
Local time
Today, 21:16
Joined
Jan 14, 2017
Messages
18,214
Create a query identical to the record source for the tab shown in the last screenshot.
Does that give more than one record?
If not, modify the record source!
 

DevAccess

Registered User.
Local time
Today, 13:16
Joined
Jun 27, 2016
Messages
321
Create a query identical to the record source for the tab shown in the last screenshot.
Does that give more than one record?
If not, modify the record source!

Hello I tried that way but it is not working, sorry for late reply as I was on vacation.

My concern is one resume ID can have many education, certifications, positions.

Would you please help me on this ?
 

isladogs

MVP / VIP
Local time
Today, 21:16
Joined
Jan 14, 2017
Messages
18,214
Hello I tried that way but it is not working, sorry for late reply as I was on vacation.

My concern is one resume ID can have many education, certifications, positions.

Would you please help me on this ?

Saying it isn't working doesn't help me help you.
What does happen? No results? Error message?

As well as answering that, please don the following in your reply
1. Restate your problem in the message text
2. Give the query / record source used.
Make it clear what fields you want to include

Suggest you also upload your db with some sample data
 

DevAccess

Registered User.
Local time
Today, 13:16
Joined
Jun 27, 2016
Messages
321
Saying it isn't working doesn't help me help you.
What does happen? No results? Error message?

As well as answering that, please don the following in your reply
1. Restate your problem in the message text
2. Give the query / record source used.
Make it clear what fields you want to include

Suggest you also upload your db with some sample data

Hello, here is the attached database,

Open the db use shift key, open form main menu create new record, what i want is I want is I will enter all the details for Name and ID in first tab and educations/certification and so on in rest of tab.

Once I enter all educations and certifications details related to Name and it should display all the related educations and certis once you save it.

on Main menu edit existing record is not working but that is not big deal, I will make it work, I am just concern about education and certification record related to given person name.

Please let me know if you need any further details

Many Thanks
 

Attachments

  • ResumeBuilder.zip
    546.3 KB · Views: 84

Users who are viewing this thread

Top Bottom