Oyseka Posted December 2, 2008 Share Posted December 2, 2008 Hi, I have table with packing list data that looks up the transport cost from the transport table. The relationship from the packing list to the transport costs are: Transporter Transport Centre Packaging Type The first matching record in the Transport costs table shows 1.93 but the transport cost brought in to the packing list shows 1.86 There is a 1.86 shown in the transport costs but that is the third matching record not the first. How am I managing to knack this The screenshots show 1). the packing list with the looked up transport cost(Tr_cost) 2) the transport cost list Thanks in advance Chris Link to comment Share on other sites More sharing options...
bcooney Posted December 2, 2008 Share Posted December 2, 2008 It looks to me that using only 3 predicates in the relationship is not enough to return just one matching record. It's returning the first record it matches (probably the first one created in the table unless the relationship is sorted (current sort order is not affecting which record is returned). Link to comment Share on other sites More sharing options...
Oyseka Posted December 2, 2008 Author Share Posted December 2, 2008 There is a sort order in the relationship which is Company Tr.Centre Timestamp Link to comment Share on other sites More sharing options...
bcooney Posted December 2, 2008 Share Posted December 2, 2008 Why do you need Company and Tr. Center? You're matching on Company and Tr. Center in the relationship, right? Can you show a png with the timestamp field? And why do you have multiple rates for the same Company, Tr. Center, Packaging Type anyway? Link to comment Share on other sites More sharing options...
Oyseka Posted December 2, 2008 Author Share Posted December 2, 2008 The Transport PNG shows the timestamp at the far right. The reason for having different rates is that the rates change with incredible rapidity, just about every time the fuel price changes, so with each new transport rate given by the transport company a new price is given to a pallet price. The old prices are kept for analysis over time Link to comment Share on other sites More sharing options...
bcooney Posted December 2, 2008 Share Posted December 2, 2008 (edited) I don't see a timestamp, I see a date. The relationship should sort by timestamp desc (and I assume that this is a record creation timestamp). Edited December 2, 2008 by Guest Link to comment Share on other sites More sharing options...
Oyseka Posted December 2, 2008 Author Share Posted December 2, 2008 It is a Timestamp field with date and time and its a modification timestamp with the field sorted descending Link to comment Share on other sites More sharing options...
Oyseka Posted December 2, 2008 Author Share Posted December 2, 2008 WHOOOA, hold that thought, I had the sort order ascending, Thank you very much for your help, that resolves it Chris Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5766 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