Linking Labels on a Form

[J. Trucking]

Hello,

Just a quick question. I am creating a billing system for a friend.
His employees can have up to 5 different charge out rate depending on
whether the work is out of town, in town, etc. I have a table (and
corresponding form) which shows the employee information. I have
inserted 5 text boxes for the five billing rates. What I am wondering
is if I can somehow create another form where admisitrators could
enter in the five billing descriptions and then they would
automatically show up on the labels of the text boxes on the employee
form. If a description is blank, then I would like the label on the
employee form to read "N/A". Any ideas on how I would do this?
Thanks in advance for any advice.

John

 

[Allen Browne]

So there are 5 different rates for the 5 different types of work? This
information needs to be in a related table, not 5 columns in your main
table. Otherwise you have not build a relational database, merely a
spreadsheet in Access.

1. Create a little table to define the different types of work and their
rates:
WorkTypeID Text (24 char) Unique name. primary key
WorkRate Currency Dollars per hour for this type.
Enter the 5 rows.

2. Create your invoice table with fields like this:
InvoiceID AutoNumber Primary key
ClientID Number Who this invoice is charged to
InvoiceDate Date/Time
...

3. Create a table for the invoice line items, like this:
InvoiceDetailID AutoNumber primary key
InvoiceID Number which invoice this line belongs to
WorkTypeID Text (24) relates to the first table
Quantity Number how many (hours or whatever)
ChargeEach Currency dollars per quantity
DetailDescrip Text optional explanation of this row.

Now if you need to write an invoice for 2 hours @ $50/hr plus 3 hours @
$75/hr, you just enter 2 rows in the invoice.

There will undoubtedly be other fields/aspects to this, but that's the core
concept.