maxmangion
AWF VIP
- Local time
- Today, 00:14
- Joined
- Feb 26, 2003
- Messages
- 2,805
I have a table in a database and I am planning to divide it in two tables. The current table contains information about stamps and at present it also contains 3 fields to contain the number of duplicates of each stamp. The table is as follows:
tblstamps: stampid, stampdescription, yearofissue, mintduplicates, usedduplicates, damagedduplicates etc.
Now I am planning to remove the last three fields from this table and create the following:
tblstamps: stampid, stampdescription, yearofissue etc
tblduplicates: stampid, duplicatetype, quantity
The main benefit which I see is that for each stamp that there are no duplicates there will not be three fields displaying 0, and the fact that now I will have a duplicatetype field instead, it will be more flexible to create even more duplicatetypes than just limited to those three types.
With the original design when it comes to the inputting of duplicates stamps, I have a tabular form where it has the following fields:
frmduplicates: stampid, mint, used, damaged Total
example 1 1 2 0 3
Therefore with the split tables now I would like to know if it is possible to keep a similar input form where the duplicatetype will be as column headings and each stamps will have just a single record displayed. I managed to achieve this by using a crosstab query, however, the problem is that it is not updateable.
Any suggestions how can i tackle this will be greatly appreciated.
Thank you
tblstamps: stampid, stampdescription, yearofissue, mintduplicates, usedduplicates, damagedduplicates etc.
Now I am planning to remove the last three fields from this table and create the following:
tblstamps: stampid, stampdescription, yearofissue etc
tblduplicates: stampid, duplicatetype, quantity
The main benefit which I see is that for each stamp that there are no duplicates there will not be three fields displaying 0, and the fact that now I will have a duplicatetype field instead, it will be more flexible to create even more duplicatetypes than just limited to those three types.
With the original design when it comes to the inputting of duplicates stamps, I have a tabular form where it has the following fields:
frmduplicates: stampid, mint, used, damaged Total
example 1 1 2 0 3
Therefore with the split tables now I would like to know if it is possible to keep a similar input form where the duplicatetype will be as column headings and each stamps will have just a single record displayed. I managed to achieve this by using a crosstab query, however, the problem is that it is not updateable.
Any suggestions how can i tackle this will be greatly appreciated.
Thank you