Show many shades on a products form

[Guest]

Hi i have a many to many relationship between products and shades, my
mainform is based on a query where i can enter data into the tables i need to
enter in the product name and the shade name here are my table structures
(See blow)

I want to have a sub form that displays all the shades for a given product,
for example if product 1 has 2 shades red and blue it will display this when
ever i show product 1 on the form i can add in 2 of any colours but product 2
could have red and blue as its shades also.

My problem is with displaying the shades for the product any help would be
great thanks

tblProducts
ProductLineID PK autonumber
strProductName

tbl Shades
ShadesLineID PK autonumber
strShadesName

tbl ProductShades
ProductShadesID PK autonumber
intProductID FK to tblProducts.ProductLineID
intShadesID FK to tblShades.ShadesLineID

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Guest]

Hi Peter

That link will not open ,

if i go to www.rogersaccesslibrary.com i can get into the site can you point
me to the example

thanks

 

[Peter Hibbs]

Yes, click Other Developers Libraries, find my name in the list and
click Flex Grid Demo.

Peter Hibbs.

 

[Guest]

Can i get more help with this as i don't understand it

 

[Peter Hibbs]

Sorry, what exactly do you not understand?

Peter Hibbs.