Question Locked

How to add a field with a record ID in existing MS Access table?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table that has only two fields: one is the PATIENT_ID and the second is DRUG_NAME. There are multiple records with different DRUG NAMES for each patient ID. I am trying to figure out a way to add a third field that would say DRUG_1, DRUG_2, etc.

Any thoughts?

3 replies

by john.a.wills

1. open the table
2. position the cursor where you want the new column to be
3. ALT Insert, Column
4. You will get a column hight Field1, but you can rename it.

by lee

Easier to create a third table combining Patient_ID and DRUG_NAME with a one-to-many relationship.
Would be like
Patient_ID DRUG_NAME
0001 xyz
0001 abc
0001 lmn

etc.

This discussion is closed to new replies.