Search results

Reading this on saturday. I will invest the time and follow up on your urls. Thank you for your concern and help.

No offense taken. I think I understand the normalization idea. I get that it is not necessary to store the same data multiple times. I am trying to provide a friend a way to store many transactions as they occur to different patients over the year. So one week a patient might come in and...

Sounds like you just made a sale. Thanks. I will try it and see what happens. As a newbie to Access this all is incredibly fun and interesting. Again, thanks for your quick reply and help.

I don't believe I need a sub form as what I am really interested in is the data on the Transaction form. That form supplies the data that is stored in the Transaction Table. I will think about this for awhile as it does seem that if I were to display both the Patient information along with the...

The Transaction form has all of the fields that are in the Transaction Table. I get the ID from a Patients table. I also want the Last, First name and two other fields that are in the Patients table to populate the Transaction form. Then I want to save all of those fields data to the...

Maybe I am going about this incorrectly. Here is what I want to do. Use a combo box to get the ID for a patient, and then fill in the rest of the Transaction form and finally save the completed form back to the Transaction table. Is the method I am using not the correct way of going about...

That sounds correct. Do you mean use the Dlookup function in each of the control source fields in each individual field?

Dbguy- I actually am trying to save the "redundant" data as the form is to fill a Transaction table and the data is pulled from a Patient table. So there is a one to many link and there are many "transactions" for one patient. I see that the code I have has no reference to the Transaction...

I have just started using Access and have come upon this problem. I have a combobox on a form which displays information from a Patients file indexed on a PatientID. The form the combobox is on (Transactionfrm) fills out 4 fields from the Patients table when this code is placed in the on...