One to many relation

dpeel2757 · Post by **dpeel2757** » Mon Mar 03, 2008 7:29 pm

I have another problem that I can't seem to wrap my head aroung and find a solution so hopefully someone can help.

I have a products table which contains information about the cabinets in my database. Each cabinet has a list of prompts that are assoicated to it in a prompts table. These tables are linked through a ProductsIndex column. Each row in the prompts table is a differrent prompt.

I want to display my report so that i see the following:

1 Door Base Product (Product Description from Product Table)
Width 18 Height 24.5 Depth 26 (Products prompts coming from the prompts table) These would appear on a single row.

I have almost accomlished this using a combintion of groups and cross-tabs but haven't got it perfect. Any ideas would be great. Again thanks in advanced.

Stephan1 · Post by **Stephan1** » Tue Mar 04, 2008 1:34 am

Have you tried a Master and Detail Report ?.

Where Master is your Base Product and the Detail is your prompts table.

Give it a try. Also there are examples for this

Stephan