Re: Re: Best approach in sales and purchase from supplier link key ?
May i know why you said should link thru supplier ID ?
As for my case my supplier ID only appear in my supplier purchase table. and it does not appear at sales table.
see the enclosed.
Edit :- i think i understand why you suggest link thru supplier ID is the best option , as it will be able to provide a lot of analysis. for example , each items should i can know which supplier we buy from and how much it our purchase price. For my case since my sales order table does not have supplier ID field. so alternative i should link thru date it is correct ?