I have existing product table. I created two new tables: 1) ProductGroup, 2) ProductXRef.
For example, I sell 4 Joomla products. I want to create a ProductGroup called "Joomla", and link it to the four existing Joomla products (for purposes of sales reports).
I want to build a page that updates productGroups (already done with ASPRunner), and a page that allows data entry of the xref table.
Do you have any built-in support for the two-way join, i..e a join table that has two masters tables?
Or do I have to create two ASPRunner projects to handle this?
On the Add xref screen, I would like to pick the product title from a list. How do I tell ASPRunner to pick an xref table from a list?
Here are the two new tables:
CREATE TABLE [dbo].[productGroupXref](
[pgx_id] [int] IDENTITY(1,1) NOT NULL,
[pgx_prod_id] [int] NULL,
[pgx_group_id] [int] NULL,
CONSTRAINT [PK_productGroupXref] PRIMARY KEY CLUSTERED
(
[pgx_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[productGroup](
[pg_group_id] [int] IDENTITY(1,1) NOT NULL,
[pg_title] varchar COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pg_date_added] [datetime] NULL,
[pg_who_added] varchar COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_productGroup] PRIMARY KEY CLUSTERED
(
[pg_group_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Thanks,
Neal Walters
http://CMSTrainingVideos.com - Learn Content Management Systems
