Automatically change records

  • Thread starter Thread starter chlaw
  • Start date Start date
C

chlaw

Hi all,

I've started to learn Access since a few days ago, but I have to
complete a task in this week. In my hand, there are 4 database tables,
Customer, Order, OrderDetail, and Product. I want to create a form for
customers' use. Here are some problems I encounter:

(1)
Here is the table Customer:
Customer(CustomerID, Company Name, Country)

In the form, the user can browse from a combo box to select a
company name. After the selection, a textfield should automatically
show the corresponding country.

(2)
In another form, there are two subforms. The first subform shows
a list of orderIDs. When the user click on an orderID, the details
like product name, unit price, quantity, etc. will be shown in the
second subform.


I searched from some books but can't find the solutions. I don't know
how can I create the form such that some fields will be changed
once another field is changed. Also, I actually do not have a concept
on solving problem (2). How can the second subform totally changed
according to the first subform?

I am really a layman in Access, so I think that I may have asked
something nonsense. Please help me. Thanks.

Regards,
chlaw
 
chlaw said:
Hi all,

I've started to learn Access since a few days ago, but I have to
complete a task in this week.
Click to expand...

Sounds like a homework assignment to me.

I'd suggest you do it yourself.
 
Mike said:
Sounds like a homework assignment to me.

I'd suggest you do it yourself.
Click to expand...

Yes. It's a homework assignment. But I'm not a student of that course.
Anyway, I need some helps. Can you help me?

chlaw
 
Back
Top