new db fill in help 2 issues

[Gerry Cousins]

Hello,
Issue 1
I have just created a new db for tracking musical
instrument rentals.
I have one table named rentals and another table named
pricing. The pricing table has item#, type, description
and price. I have the same fields on the rentals
tablealong with other customer data fields.
I am trying to have access put in the type,description and
price automatically into the rentals table when I enter
the item number in the item# field. I should be able to
have the data come from the pricing table by using the
item# field as the key link.
I am somewhat farmilar with db's from other companies but
not MS.

Issue 2 How do I get the db to access the last record
upon startup? There must be a setting somewhere but I
can't seem to locate it. To clarify, when I open the db to
input data I would like to begin with the last record (new
record) not the first in the db.

Thanks in advance for any advice.
Gerry

 

[TC]

Gerry, you need to read this article:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC

 

[Gerry]

John,
Thank you for your reply.
Yes I do have 2 tables. One named customer rentals (which
is the customer data- name address etc) One named pricing
(which is the instrument data - item,instrument
type,make,model,price)
On the customer rental table I have the "item" field in
which I want to enter the item number and have the
instrument,type,make,model,price, show up on the customer
rental screen upon entering information in the "item"
field.
I guess the question is: What procedure and field
designation would I use?
I believe that I have to make the "item" field execute a
query and then have the pricing information viewed on
screen. How is this accomplished? Thanks again in
advance. Gerry

PS I made the two tables in order to avoid storing data
redundantly.

 

[John Vinson]

John,
Thank you for your reply.
Yes I do have 2 tables. One named customer rentals (which
is the customer data- name address etc) One named pricing
(which is the instrument data - item,instrument
type,make,model,price)

In that case your tables are NOT CORRECTLY STRUCTURED. Please reread
my message.

On the customer rental table I have the "item" field in
which I want to enter the item number and have the
instrument,type,make,model,price, show up on the customer
rental screen upon entering information in the "item"
field.

This will imply that each Customer will be able to rent one and only
one instrument. Is that the case? No repeat business, ever?

I guess the question is: What procedure and field
designation would I use?

Again... REREAD MY MESSAGE. I did explain the proper normalization, as
I see it.

I believe that I have to make the "item" field execute a
query and then have the pricing information viewed on
screen. How is this accomplished? Thanks again in
advance. Gerry

You don't need to "execute" a Query. You can use a Query as the
Recordsource for a Form; simply opening the form will make Access open
the query in the background, and you'll see the information you want.
It is NOT necessary - again! - to store the data redundantly in the
Rentals table.

PS I made the two tables in order to avoid storing data
redundantly.

You need THREE tables to avoid storing data redundantly, unless you
want to limit each customer to one and only one rental.

 

[TC]

Gerry

Not to flog a dead horse, but:

You need to read this article!

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC