I need append data from table to another

[hosni4eg]

Dear Sir/ Madam
I need append data from table (has relationship with anther tables )


the tables Students has relation with gender table and Governments and Marital
what i need when I append data from students table to Registered student I want transfer text value not key such as I need transfer text Male not 1
you can see my Example https://www.dropbox.com/s/lvhv65q5lr...ple.accdb?dl=0

Thank you
Hosni

[Homegrownandy]

I don't believe appending would be the solution you need. Leave all of the registered and not registered together on one table. If you have a registration_date field for example you could see who is registered or not without moving anything.

[hosni4eg]

I need append the students data to registered one to save the register data in save place from the relationship tables so if I change the data for example gender table the registered data will be not affected

Thank you in advance

[Homegrownandy]

If a student changes their gender then you want that to change throughout anyway. There is no need to append/delete information that already exists like this. You can separate the information you want in many better ways.

[hosni4eg]

Thank you for reply

I want inform you that file for example and I need to known how append data from table to another will value not keys

Thanks for your support

[Homegrownandy]

Its hard to understand. Could you describe what the end goal is? what do you want to achieve at the end? forget how you're going to get to that goes (be it via an append query or whatever)


What's the final outcome?