jhomer Posted February 28, 2006 Posted February 28, 2006 Question for the gallery: I have an inventory system in which i have a list of materials. These materials can be run through production but if all the m aterial is not fully produced we return that material to stock and capture the reason. The return to stock information is stored in another related table. As so i have an interface from the inventory perspective looking into a return to stock portal. my problem is with a calcualtion for the new weight. which is the origonal weight minus the used weight. I want to be able to designate the last available new weight a different color. i have tried to relate the rts info to itself to no avail and then also tried an if portal row = 1 solution but that only worked if the user was on the portal. is there a way to highlite the last new weight without having to be int he portal?? as always all help and suggestions are welcome
jhomer Posted February 28, 2006 Author Posted February 28, 2006 I'd like to but am not able to due to publication restrictions. if any one needs additional clarification on this let me know and ill see if i can better explain
Robert Kidd Posted March 1, 2006 Posted March 1, 2006 Where are the weight fields held ? In the inventory table or the return to stock table ? What do you mean by the last available weight ?. Could you create a new file with just the tables fields you are talking about ?
Recommended Posts
This topic is 6861 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