One to many relation
Posted: 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.
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.