C
Claudette Hennessy
The core of my problem is this:
I have a table tblContract, fields ShopId, ShowID, SendContract(yes,no).
There are three kinds of shows, defined by the ShowID. The requirement is
to provide a continuous form which shows contracts let per show, ie...
Shop Spring Summer Fall
Shop1 Y Y
Shop2
Shop3 Y
Shop4 Y
....
The form can be built using an outerjoin between tblShop and tblContract as
a source for a cross-tab, no problem, and correctly depicts the data.
However it can't be updated. One can't change a Y, or add a contract to
Shop2. In a previous version, I had a temporary table with the structure
tblContractTemp,ShopID, Spring,Summer,Fall, used that for the form, and then
deleted tblContract and recreated it with the new changes using VBA and
command buttons on the form. Is there a better way?
Thank you,
Claudette Hennessy
I have a table tblContract, fields ShopId, ShowID, SendContract(yes,no).
There are three kinds of shows, defined by the ShowID. The requirement is
to provide a continuous form which shows contracts let per show, ie...
Shop Spring Summer Fall
Shop1 Y Y
Shop2
Shop3 Y
Shop4 Y
....
The form can be built using an outerjoin between tblShop and tblContract as
a source for a cross-tab, no problem, and correctly depicts the data.
However it can't be updated. One can't change a Y, or add a contract to
Shop2. In a previous version, I had a temporary table with the structure
tblContractTemp,ShopID, Spring,Summer,Fall, used that for the form, and then
deleted tblContract and recreated it with the new changes using VBA and
command buttons on the form. Is there a better way?
Thank you,
Claudette Hennessy