Multiple Entries On A Same Person

[gatsby]

im doing a database for CV (curriculum vitae) of employees.

i have a challenge in adding records (Working Experience) in a same person. i have a button in a Form says Add Record but when I add a record it will go to the next entry (in Table). does anyone knows here how to work this that when I add an entry/entries it will be added to the same person, not next, not new, but same person. any codes that i should incorporate in the command button?

Thanks

[alansidman]

With out seeing your total structure, this is a shot in the dark. Consider two tables and using Sub Forms. Look at this link.

http://www.datapigtechnologies.com/f...subforms1.html

[NTC]

I believe it really is just the definition of terminology: Add record can mean add a new person - or - add a new record to the existing person (presuming there is a sub form to do that). The command button is not what you are expecting but is probably ok for what it is meant to do. Can't be more specific on a fix without knowing your data structure but to add more records about the same person then one must have a continuous sub form typically.

[gatsby]

With out seeing your total structure, this is a shot in the dark. Consider two tables and using Sub Forms. Look at this link.

http://www.datapigtechnologies.com/f...subforms1.html

oh sorry i keep on editing my reply... this one is working but i cant save the new records. this will only show existing data but how about new data? lets say Sam Smith has data, and then i will add more data under him, when i save it cant, the error is below:

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefinethe index to permit duplicate entries and try again."

problem is that i cant redefine the duplicate set to YES and change the primary key.

[gatsby]

I believe it really is just the definition of terminology: Add record can mean add a new person - or - add a new record to the existing person (presuming there is a sub form to do that). The command button is not what you are expecting but is probably ok for what it is meant to do. Can't be more specific on a fix without knowing your data structure but to add more records about the same person then one must have a continuous sub form typically.

i guess its the same suggestion with one above you? but my problem is the new record/s for the same person cant be saved.

[lzook88]

Can you upload your database? That way we can see what you are working with?

[alansidman]

Attached is a simple db with two tables and a form with a subform. One table has the donor information. The second table has information about the donation. The tables are linked via a primary key and foreign and are represented in the form and subform

[gatsby]

thank you all for your replies. i think i got it now... but let me check further especially the reporting..

[gatsby]

the reporting has a problem. anyone knows what code i should place either in Event Procedure or Macro that i want to get value of the specific ID of a certain person..... like Sam Smith has 223366 ID and i wanted to get his records ONLY because now when i make the report it will give me all the records in the Table.

[lzook88]

something like below is what you are going to want to go with. This way you can change who the report is consistently.. Does your report have their name on it or their ID number?

'to open it based on their ID Number
DoCmd.OpenReport "REPORT NAME", AcViewReport, , "[ID]=" & (idnumber) & ""

'to open it based on their NAME
DoCmd.OpenReport "REPORT NAME", AcViewReport, , "[Name]='" & THEIRNAME & "'"

To select which person you want a report on, I suggest a combobox of some sort to pick from in a separate form.

Zook

[gatsby]

something like below is what you are going to want to go with. This way you can change who the report is consistently.. Does your report have their name on it or their ID number?

'to open it based on their ID Number
DoCmd.OpenReport "REPORT NAME", AcViewReport, , "[ID]=" & (idnumber) & ""

'to open it based on their NAME
DoCmd.OpenReport "REPORT NAME", AcViewReport, , "[Name]='" & THEIRNAME & "'"

To select which person you want a report on, I suggest a combobox of some sort to pick from in a separate form.

Zook

thanks for your reply.

name and ID number are there in the report.

combobox? i think not a good since there will be like 600 records in it.

i try to experiment with your code now and update my thread once done.... again, thanks.

[alansidman]

Instead of a combo box, you could build a custom filter. See the following link.

http://www.datapigtechnologies.com/f...tomfilter.html