Adding a new record with same information

[priyaradha]

Hi everyone, i need some help on doing this project from my friend he is a travel agent who has this form that was created like 13 years ago so he wants me to modify it, i am new to access but i think i could do it with a little bit of help well this is my question.

Q1)
I have this form in access that contains travel information about the passanger like number, name address, plane info and so on. So my firend wanted me to modify this. He wanted me to add tihs feature which is for example my name is Rick and my information is already stored in the form, but my son is Tom so instead of entering the address of Tom, i click the find button and look up the phone number and after it displays its results i modify the field with Toms name and instead of over writing James record i create a new record for Tom.


Q2)
My second question relates to the second one here is an example: I pull Rick's record and i want to konw how to how to create antoher table to pull up record of ricks family by phone number showing there travel information.

Here is the screen shot of my form

[Omar Anwar]

Ans # 1) U need to use append queries for this purpose and the both the destination and the sourse of this query will be the same records table. first use criteria to find the record and then change the name of person. saving it in append query will create a new record instead of modifing the old one.

[Omar Anwar]

A # 2) simply use criteria in query to find record with help of phone #. u can use query wizzard for both the answers but in the first case, u will have to change its type in the end.
I m a bigginner my self so escuse me for not explaining this well.

[priyaradha]

Thaks alot will try the suggestion...