INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

changing a field from one table to another

changing a field from one table to another

(OP)
Apologies, I put this original message in the wrong subject area.

I am using MS Access 2010 and have normalised the table via
Database tools -->  analyze table and split a large table into smaller tables.  The problem is I accidently put the title field into product table.
I have taken off the relationship so I can move the field but it shows up as a relationship which i do not want. Later on I obviously want to show relationsip but at this stage I just want to move a field from the product table to the customer table.
  

RE: changing a field from one table to another

There are aspects of this database that are important and which I do not know about your data.  But, with that said ...
You should be able to first add the field to the customer table (an empty field with no data).

Then copy the data from the field in the product table to the field in the customer table, using an update query.

Then, once you know the data is properly in the customer table, delete the field and its contents from the product table.

What you need in order to do this is a way to "line up" the lines of data coming from one table to the proper records in the destination table.  I am having difficulty at the moment envisioning a field in a product table, with each entry in the appropriate record, and how this same field's data would align with records in a customer table.  There must be some relationship between these tables and, if that is the case, there should be a ways to set up the query to copy the data over.  Again, I am trying to see in my head the sorts of fields in a customer table and the sorts of fields I would have in a customer table.  Thus it is hard to see how the data in this field is allocated to the other fields.

My head is spinning out of control with thoughts of how a field could exist in any way in these two tables.

I don't think I can try to explain this in detail without seeing the table structure of the customer and product tables.  By structure, I mean seeing what fields are in each table.  And what the primary key is in each.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close