Auto-population

[jkoer]

Here is my dilemma that I'm trying to figure out the best way to handle. I have a table where names are associated with information. However, we are now not allowed to have any identifying information with the information, so I need to move the names to another table with some kind of indentifier to associate which patient goes with which information. I was thinking about having the auto assigned ID numbers act as the ID numbers for each set of information. So I need find a way that when someone enters information in the main table, they then enter the name into the "ID table" with the same autoassigned number. Is this possible? The problem now is there is already information in the table, and since data has been deleted, the ID autoassign field has gaps. I also don't know if I can set up an autopopulate field. Any advice on how to make this easier or how to create the autopopulation would be greatly appreciated.

 

[MarkK]

OK, I'm not sure I got it, but you have names related to information, but any information that identifies that information is too informative, and therefore needs to be obscured. To do this you want to introduce ID numbers to identify the information instead of the names, and then when someone enters information in the information table, that's fine, but the names should go in the names table, and then get connected by the IDs? But the IDs have gaps? Why does it matter if there are gaps in the IDs? And then you said about autopopulation, but autopopulation of what? That's what I think I don't get is what gets autopopulated and why and how?

Does that make any sense?

Mark

 

[jkoer]

Yep. You have the gist of what I'm trying to do. I want use the first column (the key ID columns that are auto assigned when you add a new row) of the "information table", and I want to any new ID numbers that are added to be automatically added to an "ID" column in my "Names table." Does that make a bit more sense?

 

[John Big Booty]

You could do this with a Form/Subform set up.

The main form would be bound to your patient details table that contains all the patient personal details. You Subform would contain all the patient records and be bound to a your patient records table. The two table would be linked via the PatientID.

As your user adds records to the patient records via the sub form (so long as the form/subform set is correctly configured) the appropriate PatientID would be added to each new record automagically.