Updating in Particular Order

[feebert]

I have an update query that append new instructions to a memo field. This query just randomly adds lines to the memo field in no particular order. Is ther a way to update the memo field in an orderly fashion!!

Example

I have a part called XYZ and it has an extended description Field(memo) used to hold cutting instructions etc.
My cutting Instructions are in another table that looks something like this.
Record 1-PartNumber(XYZ) / Instruction1(1-Cut 2 at 4 inches)

Record 2-PartNumber(XYZ) / Instruction(2-Cut 4 at 6 inches)

What I need to do is enter the PartNumber in a new table and enter the instructions sequentially.


Is there anyway to do that!

Thanks in advance for the help

 

[Jack Cowley]

If the cutting instructions already exist in another table for each part then you should properly relate the two tables. Selecting a part will then show you a list (from the other table) of all the instructions.

hth,
Jack

 

[feebert]

The reason I need to do this is because I'm writing from one database to another.

The one database has all the instructions in a seperate table but the one I have to update does not have a seperate table and therefore requires me to enter all the instructions of the particular part in one field. And no I can't create a new table in the database.

 

[Jack Cowley]

I can't imagine why you can't add a table to a database but if you say you can't then you can't. Your original post said, "What I need to do is enter the PartNumber in a new table (my emphasis) and enter the instructions sequentially." How about linking the table to the database you can't add a table too? That does not add a table to the database....

Jack

 

[feebert]

Thanks for your reply. I think I have to look at my process and determine if there's an easier way to accomplish what I want.

I really appreciate your answer. Thanks a million.

 

[Jack Cowley]

You are welcome. It is hard to know just what it is you are trying to accomplish so I am sorry that I could not give you more detailed information on some other possible approaches....

Jack