I am comparing two fields from two different tables. field is the article number, one from the ordertable which can have several articles and one from the origin table which has all articles. now i want all articles shown from the origin and the article quantity from the ordertable. how do i manage this task?
i can show all articles but after i put in the quantity, all articles not in the ordertable are supressed or hide away, can i avoid this behaviour?
thanks for any reply. if you have further question or need the report let me know.