Hello all,

I have an extremely cumbersomely designed database that I am working on updating. Because of several reports that are highly intricate and based off of the database, I am not able to change many things. The database also has one key form (containing multiple tabs and sub-forms). This form feeds off of a query that pulls from two tables (main1 and main2). There are too many fields for one table and I need to be able to store fields for the same record across two tables.

My issue is that when a new record is added to main1 through the form, a corresponding record is not created in main2. I have created a one to one relationship and enforced referential integrity, but it is just not working for me.

I am open to any comments about how this can be done easier (other than re-arranging the core two tables, I am too far in).

Mike

i think you want to reconsider using one table. did you normalize it?

sam