We help IT Professionals succeed at work.
Get Started

Access subform\table lookup and validation

kwilsokl
kwilsokl asked
on
1,063 Views
Last Modified: 2012-05-06
I have an access 2003 database that has 3 table and 1 form with 2 sub forms nested in it.

The main form which has 2 sub forms (Serviceplan, and claims) where a user will input some information that deals with services, units and cost per unit. . in the first sub form ServicePlan a user will select a service they are performing, the number of units and the rate.

The second sub form is for claims to be submitted against the (serviceplan subform). There is a table that stores  67 services with different rates.  

Here is what I need to do but I don't know where to start.

when a use fills out the (ServicePlan) sub form I need the form to not allow a price over the caped amount that is stored in the service table.

SO for example if they said I can do a service for $50 per hour and it will take me 2 hours. I need this to look at the service table and see if the $50 per hours is not over the rate we are willing to pay. so if the rate in the service table was $60 then it would except the $50 value.

Then in the claims subform if they would submit a claim against the service plan they generated in the above ServicePlan subform.the above sub form should only except claims at the rate that was approved and specified in the ServicePlan sub form.


Sorry it is very hard to communicate. Basically what we are trying to do is only except services that are within our budgeted amount and once the service is accepted only allow claims against the agreed amount.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 3 Answers and 4 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE