form fields fill automatically based on prior selection

[hlkelly]

I have three tables: orders, order details and reps
For each order, there are details, for each detail, there is a rep.

I need to be able to pull in the rep details for all future orders for a particular client for a particular item. For example, Client A orders Item 1 and Item 1 was sold by Rep ABC. In the future, I need Item 1 to always reflect that it was sold by Rep ABC for Client A without the rep having to go into each order and make the change.

Can this be done? Does this make sense? Please help if you have a suggestion.

Thank you very much!

Heather

 

[ProgramError]

Hi Heather,

If what you mean is you want a n item to always show it was sold by a particular rep then you need to add an additional field to your items table and in this new field make it lookup the rep from your rep table. From then on your item will always be 'tide' to your rep. It could easily be changed by selecting another from the rep table if you ever wanted to.



Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[hlkelly]

That makes sense but...if the rep is based on each order, that wouldn't work, right? Because the same rep would always appear for that item 1 even though a different rep sold it to someone else.

Each rep gets commission based on the item they sell to a particular client. I always want the reps initials to appear for that item for that client so they receive commission on future orders.

Am I making this harder than it has to be? Probably...

Thank you!

 

[TheAceMan1]

How are ya hlpoindexter . . .

Have a look at the [blue]Default[/blue] property in VBE help.

See Ya! . . . . . .

 

[hlkelly]

Yipes...that didn't help at all. Not sure what you are getting at with default property...

Thanks.

 

[TheAceMan1]

hlpoindexter . . .

My post was meant for another thread! Sorry!

See Ya! . . . . . .