Re: Linking database

buck.matthew74@xxxxxxxxx wrote:
I am a business. I have a contact database. My contacts order goods
from me, therefor I have an Orders database. In reviewing my contacts
and following up on sales possibilities, is there a way to link my
contact database field "Company" so that when looking at my Orders I
can find that "Company" 's Orders. Or can you suggest how best to link
the Order records to my contact file?
Thanks



Use Company_ID in Contacts. In case you are not using a Company_ID, Contact_ID, Order_ID, you should be.

either a self rel in Orders
Order::Company_ID to Order::Company_ID

or a selectable ComapnayID using a global, to to Order::Company_ID in Orders


Chris
.