Automatically copy value from Table B to Table A

[ybn1197]

I'm sure this has been answered before, but being new to this I must have missed it. I am trying to create a customer database for a friend of mine who runs a comic book store. The problem is with the subscription field on each customer record.
In tblCustomer, there is a subscription field. This is the field that holds the number of books set aside each month for that customer. There is also a discount field. This is the discount the customer receives based on the number of subscriptions.
In tblDiscount, there is also a subsciption field and a discount field. These hold the predetermined values to be used in tblCustomer.
What I want to do is input a value in Subscription.tblCustomer, have tblDiscount queried on that value and automatically place the discount in Discount.tblCustomer.
I am using Access 2000 to create the database. Could someone please help me with this.

 

[RobPotts]

Hi,

If the Subscription always results in the same discount (i.e 5 books always give 10% discount, regardless of who the customer is) and any changes to the discount policy were across all customers and not just new ones, why do you not just view the results of the query, or a form/report based on that query. That way you could do away with the discount field in the TblCustpmer table.

Hope this helps
Rob!

 

[ybn1197]

I thought about that, but the next problem I ran into was integration to a web page. Eventually, he wants this to run in an intranet style setting. I don't have my ASP books in front of me so I don't know if ASP is capable of pulling up that data directly from the form, which is why I figured on just copying the data directly into tblCustomers. I know that ASP can pull the information from there.
If ASP can pull that information from a Form, great. I'll be set. Otherwise, I need to know how to import that value into the Customers table.