Data mismatching

[fudalij_t]

I have a table labeled Cancer treatments with an ID field, number format, incremental, and a Name field(which houses the name of the cancer treatment), text format. Then I have another table that is linked to this table that pulls in Diagnosis(from another table), Cancer treatment(from this table I am talking about) and Patient information(from another table). All of the information is added to the linked table via a form. The problem is that I added more types of Cancer treatments to the Cancer treatment table and the linked table field for the cancer treatment jumps off by one after adding a new records to the Cancer treatment table. I have compared this table to my Diagnosis table to see where the programming might be an issue on the form, but from what I can tell the Cancer treatment is showing up in the linked table by the "postition" it was entered on the form. Any help is appreciated and if you need more information please feel free to contact me, Thanks

 

[DCrake]

Don't get what you mean by Drops Off can you elaborate a bit more please.

 

[Dennisk]

Two reasons, spring to mind,

1) does the Cancer Treatment table have an auto numberID, if not You may have two treatment entries with the same ID.

2) Similar to above, I have seen combo box that do not show the correct value and they are out by one and that is where you have 2 keys identical except for the case. The table I was looking at had drug READ codes for the ID. These codes are case sensitive.

so If the table had these two records in

DRA001 Aspirin 5mg
DRa001 Aspirin 10mg

and you select the second entry from a combo box, when you select the patients record again, it will show the first entry even though the code may be correct in the patient file i.e. DRa001 shows as Aspirin 5mg