Hi
Is it possible to create a one-to-one realtionship between e.g., table_A and table_B, table_A and table_C... Table_A and Table_F. With referential intergrity whilst not all tables will have data in them (and therefore the record will not exist). And finally allow edits to existing data in any table and additions to tables that have none existent data.
I don't seem to be able to do it unless I create a record in each table (whether it be blank or not) when I create the initial form - which seems a little wasteful as it is possible that not all tables will be populated.
I think I need the seperate tables to keep the DB tidy and allow for efficient queries.
Any help would be gratefully accepted!
Thanks
Lex
Is it possible to create a one-to-one realtionship between e.g., table_A and table_B, table_A and table_C... Table_A and Table_F. With referential intergrity whilst not all tables will have data in them (and therefore the record will not exist). And finally allow edits to existing data in any table and additions to tables that have none existent data.
I don't seem to be able to do it unless I create a record in each table (whether it be blank or not) when I create the initial form - which seems a little wasteful as it is possible that not all tables will be populated.
I think I need the seperate tables to keep the DB tidy and allow for efficient queries.
Any help would be gratefully accepted!
Thanks
Lex
