hello,

i created a new table called llocation and i have a form with 3 text boxes and i button called add
when i fill the textboxes all information goes to llocation table. what i want to do is when i press add i want all the new info at llocation table populates to another table called alllocations table which is the primary location table.

i couldnt manage to do is.

Can u help me?

Thank you very much

I am sue it is possible to do but why are you duplicating the data?

I think the reason you are not finding this easy to do is that is violates the rules of database normalization and should be avoid.

Before you attempt to duplicate the data I would recommend rethinking your database design.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015