importing information from one layout to another
I have a database with several tables, all of which contain a certain type of information about a study. Each study has a specific protocol number that is unique to that study, and so I have linked the tables using this unique number. So, here is one one main table (Table A) that has the protocol number, the name, and the lead investigator as wel as bunch of other information. Then there are other tables B-D. Each table B-D has a field for the protocol number, and in the layout I brought the fields for study title and investigator from Table A into the layout I use for table B-D so that once I enter in the protocol number, it just automatically puts the matching invesitgator and study title into the layout.
okay, phew, so my problem is that I want to enter in a study title and investigator before the study gets assigned a protocol number, but when I go to table B-D, it won't let me type anything into the field for study title and investigator. is there an easier way to do this?