Need HELP with 2 Major Questions/Issues

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Issue 1:

I've created tables with multiple entries of names of shops, and types
of invoices. Shops has its own table, and invoice type has its own.
I have established relationships between them and the database,
However, when I open the form, only shops has a drop down list.
Invoic3e has a drop down box showing, but there is no information to
shoose from> Can anyone tell me what I am doing wrong here?

Issue 2.

Is there any way to perfom calculations within the database itself? I
have a field named "Miles Towed," "Mileage Rate," and "Mileage
Charges." Is it at all possible to have the datbase multiply the
"Miles Towed" by the "Mileage Rate," and have that total put in the
"Mileage Charges" cell?

TIA for any and all help on these issues /questions.

Jerry
 
Without knowing anything about how you've done things, it's not possible for
anyone to answer your first question.

For the second one, calculated fields shouldn't be stored in tables. Rather,
create a query that has the calculation in it, and use the query wherever
you would otherwise have used the table.

If it were my database, I'd be storing Mileage Rate in a different table
than Miles Towed, since the rate can change over time.

Just to answer the specific question, though, no, it's not possible to
define a table field in terms of others.
 
Issue 1:

I've created tables with multiple entries of names of shops, and types
of invoices. Shops has its own table, and invoice type has its own.
I have established relationships between them and the database,
However, when I open the form, only shops has a drop down list.
Invoic3e has a drop down box showing, but there is no information to
shoose from> Can anyone tell me what I am doing wrong here?
Click to expand...

Well, apparently one thing you're doing wrong is using a table
datasheet for data entry. DON'T. Datasheets have very limited
capabilities; and the abominable, misdesigned "Lookup Wizard" frankly
does much more harm than good; for a critique see

http://www.mvps.org/access/lookupfields.htm

Use a Form (with combo boxes for your dropdown lists) instead.
Typically one would use a Form for the shop, and a Subform for the
invoices for that shop.
Issue 2.

Is there any way to perfom calculations within the database itself? I
have a field named "Miles Towed," "Mileage Rate," and "Mileage
Charges." Is it at all possible to have the datbase multiply the
"Miles Towed" by the "Mileage Rate," and have that total put in the
"Mileage Charges" cell?
Click to expand...

As noted elsethread... DON'T store this in a table. You can calculate
it directly in a Query or in the Control Source of a textbox on a
Form.
 
Back
Top