Ok here I am again.
Please look at the relationships. When I create the primary and foreign keys I successfully get the data to align. Ideally the primary key in the advance directive table should match with one say the DVT table, but they do not. There will always be a record and therefore a Primary / foreign key relatiionship between the Advance directive table and the Perioperative table. But as subprojects evolve as with DVT and Temperature there will not always be the same relation. When I change the foreign key to numberfield then nothing shows.
Also when I try to build one form for all data entry, I get the message which attached with the screen shot called "relationships11911.doc". I did set the index to no duplicates in the advance directive table.
Can you help me with this???
Please look at the relationships. When I create the primary and foreign keys I successfully get the data to align. Ideally the primary key in the advance directive table should match with one say the DVT table, but they do not. There will always be a record and therefore a Primary / foreign key relatiionship between the Advance directive table and the Perioperative table. But as subprojects evolve as with DVT and Temperature there will not always be the same relation. When I change the foreign key to numberfield then nothing shows.
Also when I try to build one form for all data entry, I get the message which attached with the screen shot called "relationships11911.doc". I did set the index to no duplicates in the advance directive table.
Can you help me with this???