So I have posted here before about an issue and got a work around, however there was some ambiguities and I'd like to get a real solution.
I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)
I have a Service Order table and form that I use a drop down control in the Service order to select the customer.
In the Service Order Form a I have a continuous Subform for detailed service.
This is where I'm having the problem.
In the detail subform I want to select from a drop down box the customers particular ski that I want to service.
I can't figure out how to have only that one customers ski's to show up.
I've asked before, and was presented with a solution, basically a filter, however, though it works, I can actually insert anybodies ski ID number and since it's not bound to anything, there won't be an error, but it will be wrong.
I can't imagine this is a unique thing and if anyone has any thoughts on this, I'd appreciate any suggestions.
Cheers!
I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)
I have a Service Order table and form that I use a drop down control in the Service order to select the customer.
In the Service Order Form a I have a continuous Subform for detailed service.
This is where I'm having the problem.
In the detail subform I want to select from a drop down box the customers particular ski that I want to service.
I can't figure out how to have only that one customers ski's to show up.
I've asked before, and was presented with a solution, basically a filter, however, though it works, I can actually insert anybodies ski ID number and since it's not bound to anything, there won't be an error, but it will be wrong.
I can't imagine this is a unique thing and if anyone has any thoughts on this, I'd appreciate any suggestions.
Cheers!