I have Access2010.

I have a "tblProducts" in my database linked to "frmInvoice".

Some of the products require different names for the same thing, for
example a "Green Detergent" could be named "Supersoap" or "MildSoap"
depending on the customer.

What would be the simplest way to have many aliases for the one
product?

Please help
Peter

On Nov 23, 10:03*pm, Peter Jason <p... (AT) jostle (DOT) com> wrote:
you could use a product alias table
so you have
tblProducts
productId (pk)
productName

tblProductsAlias
productAliasId (pk)
productId (fk)
productAliasName


this would allow you to have many alias names for a product

On Thu, 24 Nov 2011 04:09:55 -0800 (PST), Roger
<lesperancer (AT) natpro (DOT) com> wrote:

Thanks. Since each of my customers have their own price lists, I can
use tblProductsAlias as the source (via a query) in place of
tblProducts?

Is there any way to post here my Relationships screen?

Peter