Search results

  1. T

    Create Primary Key from Foreign Key?

    Thanks or the further guidance, Kipcliff. This helped a lot. Project sorted :)
  2. T

    Requery Issues

    This is brilliant! Sorted.
  3. T

    Requery Issues

    Hi all, I am pretty new to Access and have already recieved some good advice from this forum (thanks kipcliff!). I am having some issues with requerying a combobox on a form. I have two tables, tblPatient with pkUMRN (not autonumber, a 8 digit alphanumeric code) and tblAdmission with...
  4. T

    Create Primary Key from Foreign Key?

    Thanks this was all awesome! I even managed to figure out some macros to open a NewPatient form, save the data and close the form. I still have one problem remaining: I can't figure out how to get the UMRNAdmission combo box entry requery after the NewPatient form closes. The tblPatients...
  5. T

    Create Primary Key from Foreign Key?

    Hello all, I am pretty new to Access. Would appreciate help with this question! I have two tables tblPatients (pkUMRN) and tblAdmissions (pkAdmissionID, fkUMRNAdmission). pkUMRN is not auto-number, but is an 8-digit alphanumeric code unique to each tblPatients record. I have set up a...
Back
Top Bottom