Access Fields

  • Thread starter Thread starter kjstec
  • Start date Start date
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
 
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
 
Back
Top