If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto field design to move info to a table
What I am attempting to do is set-up a field/query that would automatically
move a record from one table to another if a specific field has been populated. I would want the new table to keep these records. Can this be done? -- NDNobbs |
#2
|
|||
|
|||
Auto field design to move info to a table
Yes, no, why?
Yes, it is possible to get a record in one table "copied" to a table in another. No, there isn't a "field" in a table that will do this for you. You will need to create multiple queries (one to find and append the correct record(s), one to delete it from the "old" table), and you will probably need/want to embed this in code that confirms that the record was added to table 2 before deleting it from table 1. (Or you could do this all in code, using UPDATE and DELETE SQL statements.) Why would you want to? What difference does it make to your business process or users what table the record is in? In fact, I can imagine situations in which having records strung out over multiple tables would make looking up historical information quite a bother! You've described a "how", as in how you want to accomplish something. You've not described what business need you are trying to solve, i.e., what that something is. What will having a record moved from table 1 to table 2 allow you/your users to do? -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "NDNobbs" wrote in message ... What I am attempting to do is set-up a field/query that would automatically move a record from one table to another if a specific field has been populated. I would want the new table to keep these records. Can this be done? -- NDNobbs |
Thread Tools | |
Display Modes | |
|
|