Search results

Hi. I have split a large table which was about 150 fields long into 3 tables. The original table included patient details such as address, medications (tick boxes) and health conditions...more tick boxes. Can I link all tables one to one using the Patient ID number as Primary key in each new...

Hi. I am relatively new to access but I managed to create a database based on several tables. I put a form for front desk people to enter customer details by ID card numbers. When a client comes the second time, the ID number gives an error because the ID already exists. The form is set to "Data...