Data entry form

T

Tandy

I am trying to make a seemingly simple form, but am having no luck. My table
( PayType/Rate) has 3 fields (PayGroup, PayType and PayRate). The way it is
setup is that every PayGroup has three PayTypes (Weekday, Weekend and
Holiday) with different PayRates. So my table looks something like this:
PayGroup PayType PayRate
1 Weekday $10
1 Weekend $11
1 Holiday $12
2 Weekday $15
2 Weekend $16
2 Holiday $17

Right now when I make tabular data entry form, it shows only one line to
enter PayGroup, PayType and PayRate. It would be really nice for my user (who
has never used Access) if the form listed three lines, one having PayGroup
and PayRate blank, but PayType saying "Weekday", the next with "Weekend" and
the last iwth "Holiday". It would also be nice if I create a dialog box to
prompt my user for the PayGroup number and fill it in on the three lines, so
all my user would have to fill in is the new PayRates. This what I am
thinking:

PayGroup PayType PayRate
3 Weekday ___
3 Weekend ___
3 Holiday ___

I would really appreciate any help anyone could give!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top