Hi,
I have a table that stores default information called 'dat HouseType'. The information on this table appears on a form depending on the value users select from a combobox on another form; however, there will be situations where users need to change some of the fields for certain records in the default form. When that happens I don't want the changes to be stored in the 'dat HouseType' table because those records are default and should not change.
The combobox that pulls default records from 'dat HouseType' is currently storing the PK of this table in a main table called House. The PK links the two forms to show default records for each House selected in the main form.
I thought about creating another table that stores records pulled from 'dat HouseType'. Then take away the FK connection in between the 'dat HouseType' and the main table and make a new FK connection in between the new table and the main table. However, this will be storing every record saved and that will create a lot of repetition. I also can't think of how I am going to link this new table to the House table as my combo is currently pulling records from the 'dat HouseType' and it won't update the new table's FK in the main table.
Any suggestions will be very much appreciated, I can explain further if the above is vague.
B
I have a table that stores default information called 'dat HouseType'. The information on this table appears on a form depending on the value users select from a combobox on another form; however, there will be situations where users need to change some of the fields for certain records in the default form. When that happens I don't want the changes to be stored in the 'dat HouseType' table because those records are default and should not change.
The combobox that pulls default records from 'dat HouseType' is currently storing the PK of this table in a main table called House. The PK links the two forms to show default records for each House selected in the main form.
I thought about creating another table that stores records pulled from 'dat HouseType'. Then take away the FK connection in between the 'dat HouseType' and the main table and make a new FK connection in between the new table and the main table. However, this will be storing every record saved and that will create a lot of repetition. I also can't think of how I am going to link this new table to the House table as my combo is currently pulling records from the 'dat HouseType' and it won't update the new table's FK in the main table.
Any suggestions will be very much appreciated, I can explain further if the above is vague.
B