Access Fields

K

kjstec

I am creating a database for SAE (Serious Adverse Events) for Protocols
dealing with cancer. We have several protocols (i.e. E2805, E5202, C80405,
etc.) which have the same SAE. Instead of typing a new form for each
protocol number, is there a way that I can put in several protocl numbers
with one SAE number. Example:
E5202 - SAE#12345
E2805 - SAE#12345
C80405 - SAE#12345

The SAE number may also have a follow-up (i.e. SAE#12345 F/U#1) which may
include multiple protocols.

Can anyone help?

Thanks,
Kathy
 
A

Amy Blankenship

kjstec said:
I am creating a database for SAE (Serious Adverse Events) for Protocols
dealing with cancer. We have several protocols (i.e. E2805, E5202,
C80405,
etc.) which have the same SAE. Instead of typing a new form for each
protocol number, is there a way that I can put in several protocl numbers
with one SAE number. Example:
E5202 - SAE#12345
E2805 - SAE#12345
C80405 - SAE#12345

The SAE number may also have a follow-up (i.e. SAE#12345 F/U#1) which may
include multiple protocols.
Click to expand...

You need to start out with a table design that is capable of handling this.
On the scanty information you've given, this might work:

tblSAE
SAECode (PK)
SAEDesc
....

tblProtocol
ProtocolCode (PK)
ProtocolDesc
....

tblSAEProtocol
SAEProtocolID (PK Autonumber)
SAECode
ProtocolCode
....

Without more information of exactly what is going on in your database, it is
difficult to be more specific or to tell how this would play out in the UI.

HTH;

Amy
 
Top