Extract and display information from a table

[Psycolor]

I'm working on a simple database.
I have 10 products with their description. Each product has different
customer and price condition. I'd like to have a mask in which if I select a
customer, it shows me all related price/customer information and the
description of the product. I don't want to replicate the product description
for every customer who buy the same product, I'd like to have a field in the
mask which is linked to the product and automatically updates its content
when the product changes.
I tried to make a relashionship between the main table and a table
containing the products description, but it doesn't work. Any suggestion?
Thanks.

 

[Piet Linden]

I'm working on a simple database.
I have 10 products with their description. Each product has different
customer and price condition. I'd like to have a mask in which if I select a
customer, it shows me all related price/customer information and the
description of the product. I don't want to replicate the product description
for every customer who buy the same product, I'd like to have a field in the
mask which is linked to the product and automatically updates its content
when the product changes.
I tried to make a relashionship between the main table and a table
containing the products description, but it doesn't work. Any suggestion?
Thanks.

Not sure I follow. The only place the description of the product
should be stored is in the Products table. You can _show_ that pretty
much anywhere you want. Look at the northwind sample database.
That's how they do it. The Item ID gets stored, but they *show* the
item name. Simple combobox with 2 columns Widths: 0;1 (so the first
is not visible).

 

[Jack Cannon]

Your post is a little confusing.

Are you attempting to show what products a specific customer is purchasing
or are you attempting to show what customers are purchasing a specific
product?

Your use of the term "Mask" appears out-of-context within the Access
environment.

If you are attempting to link anything to Product Description, that is
wrong. Construct your links to the Product ID not to the Product
Description. That will ensure that any updates to the Product Description
will be viewed throughout the database.

Jack Cannon

 

[Psycolor]

Thanks for the answer.
I'll tray to better explain my request.
I have a database and every product has its description. I want to show the
product and its description in every customer card. If different customers
use the same product, I'd like to have a box with the product name and a box
with its description without inserting the description in every customer
card. If the customer changes product and I update the name of the product,
the description should be automatically updated too, with the concerning text.
Bye.

 

[John W. Vinson]

I'm working on a simple database.
I have 10 products with their description. Each product has different
customer and price condition. I'd like to have a mask in which if I select a
customer, it shows me all related price/customer information and the
description of the product. I don't want to replicate the product description
for every customer who buy the same product, I'd like to have a field in the
mask which is linked to the product and automatically updates its content
when the product changes.
I tried to make a relashionship between the main table and a table
containing the products description, but it doesn't work. Any suggestion?
Thanks.

What do you mean by "a mask"???

If you want to display the description information on screen, use a Query
joining the customer table to the product table; or a Form based on the
customer table with a Subform based on that customer's products.

If you want to print a "customer card" onto paper, use a Report based on a
query joining the tables.