Search results

  1. M

    Too many indexes using a lookup table

    I work on a medical research team, and we get whole specimens donated to us. When we receive these specimens, we slice them up into (up to) 35 pieces (and are tracked as 35 unique fields in the associated table). Then each piece may or may not contain certain "parts" of the whole. The parts of...
  2. M

    A heap of form issues...

    So....new to Access here, but experienced in SQL. I work on a medical research team and have a database that contains a table for patient demographic info (name/age/SSN/race/etc) and a table for autopsy information (time/cause of death, etc). The PK for the demographic table is a random...
  3. M

    Standard length on random autonumber

    I've seen a couple of posts on here related to this. I am in a similar situation as some of the other folks on here. I need to restrict the random autonumber feature to 10 digits and a positive number for a primary key. I work in the medical field, and HIPAA privacy regulations require the use...
Back
Top Bottom