overrider Posted February 23, 2006 Posted February 23, 2006 hi all, i have a few items, each of those has a on_hand_qty and a reorder_qty (qty=quantity) field. now without using some sort of global or other calculation, i want to have a portal which lists all items where the on_hand_qty is below the reorder_qty . to archieve that i made a self join relationship which looks like reorder_qty > on_hand_qty ... at first it seemed working but then i realized it doesnt...but actually produces a strange effect. i guess it is a good example of how relationships work though, and can be viewed in the easy example file i attached. if anyone can give me a hand here that would be awesome. if possible without resorting to globals and calulations. thanks a lot for any assistance example.fp7.zip
Ben Ball Posted February 23, 2006 Posted February 23, 2006 Fisrtly, I think you need to add another parameter, as for each decription. The main problem is you are using a self join and showing the current record that you are on. I have created another seperate table. I have added a TO "Decription" to show for each product only. This will show each individual item that is under you kanban limit for ordering. I am not really reading your question correctly, but as a quick over view I think this is what you are trying to achieve?? example_Copy.zip
overrider Posted February 23, 2006 Author Posted February 23, 2006 hey there. no actually this wasnt what i meant. what i need is when the on_hand_qty is less then the reorder_qty, the item must show up in the portal. once the on_hand is more then the reorder_qty, it shall disappear. it has to be on the items layout (well, id like it to), and it has to not only list the current item you are on, as that would be pointless somehow, but it has to list all items in the database which need reorder. now i attached a new file, which contains my problem on the left, and a solution which works on the right. my way however makes use of a global field which i wonder if there isnt another way. however when you want to know what i mean exactly then look at my attachment. when you open the file change the on_hand_qty to something like 100 , and then notice how the item disappears of the right hand portal. then change it back to say 2 , and see how it reappears. cheers, overrider example_g.fp7.zip
Ben Ball Posted February 23, 2006 Posted February 23, 2006 (edited) You dont need a global filed if you show the items through a different table. In any instance I would imagine you need an orders table which will show items that require ordering? I think using a seperate table is safer than using a global field within the same table?? Not sure if you want to keep track of what is being used?? I can see the advantage of seeing the items ready for order on each layout, but how will you order them from there? Are you using this table just as an alert, if you are then the global field and calculation is probably ok to use. Edited February 23, 2006 by Guest
overrider Posted February 24, 2006 Author Posted February 24, 2006 hello , yes the viewing of items which need reorder is just supposed to be a nice touch for someone working with the database..
Recommended Posts
This topic is 6864 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