James Steele Posted September 25, 2006 Posted September 25, 2006 Here is what I want to do. I have a record (item Number) with a protal (populated with Work Instruction lines that pertain to only the one Item). I have a job number record that I want to have the employee enter that will reference the item number. I would like the items that are in this Item Number Record to be copied to the Job Record (Any further changes to either record should not effect the other once the copy has happened). Script maybe?? Thanks James
T-Square Posted October 4, 2006 Posted October 4, 2006 I think a little more detail is needed. You have some record that has an Item Number--is this an Item? Later you say that a person enters a job number--is this supposed to be the Item Number mentioned above? And if someone enters the Item Number, why is there more than one item in this Item Number? An Item record should contain info about a single item. You mention a Work Instructions portal, but it doesn't sound like this has any pertinence here. Taking a stab, I imagine you're working on some sort of job tracking db, and that you have Jobs that have Instructions and require certain tools, parts, or resources. Perhaps you're trying to set up a system where if a certain type of job is requested, then certain tools/parts/resources get assigned to this job. Am I on the right track? Send us a picture of your Relationship graph, and what it is you're trying to do... David
Recommended Posts
This topic is 6627 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now