To Flag or Not To Flag? That is the question....

[spima05]

Hello

I am working on a database to track sales reps involved on a sale. I
would like to flag the sales rep that initiated the sale but read that
creating fields used to flag are not recommended. Can anyone provide a
suggestion of another way to track this information?

Below is how my db is structured (and thank you Roger from this news
group with all your help with creating this structure)

tblOrder
salesOrderID
salesAmount
customerName

tblOrderRep
salesOrderID
repID
flag (this is the field i was going to add to flag which rep
initiated the sale)

tblRep
repID
repName
tier
upline

Thank you in advance for your time and advice.
Matt