Search results

  1. D

    Form Field Results Based on ID Fields

    I have a form (FormSalary) which is generated from my "Salary Table" and was linked to another table (Employee Table) since my Employee field in my "Salary" form is linked to "EmployeeID" in my "Employee Table"... I inserted one field in my form (Name of Employee) This field is not in my...
  2. D

    Normalization of tables

    Hi please see attached file for your reference.. you need to Create 4 tables based on your sample fields. Hope this would help.
  3. D

    How to have a dropdown list

    Hi, I'm really new to Access, don't know how to do this... scenario: I need to enter a "Name" in my forms but i don't want to enter the ID# I want to have my form to show a dropdown list of the "Name" not the "ID# (primary key)...suggestions or sample file will be great.. THANKS! Table1...
  4. D

    Remove Navigation form Border

    THANK YOU So much!!! appreciate it!!!!
  5. D

    Remove Navigation form Border

    Hi i just want to know how to remove/disable this Border from my Navigation form.. (Please see attached file) thanks.
  6. D

    Dropdown List Selection

    Hi I'm new to access, I'm currently doing some projects and I dont know how to correct this small Problem (I Think) I have this 2 tables which are related (One to Many) (Table 1) with 2 fields only (ListID is my Primary Key) *ListID---------- FruitsID (Table 2) with 2 fields also...
  7. D

    Normalization of tables

    Thanks for that info. we don't have any business structure right now, im tired of using excel and I really wanted to learn MS Access. I do have one problem now... I have Table with One to Many relations to another table... my question is, evertime i enter a data, i will have this error "The...
  8. D

    Normalization of tables

    THANK YOU! can you check my new tables / Relationship... I don't really know if im doing it right... thanks again. (See attached file)
  9. D

    Normalization of tables

    Hi Im new to Access and Im trying to create a database of employees with their corresponding details and informations. but I am confused on how to link each table.. I attached the file for your reference, please help me Normalized my table and how to create PK & FK ..thanks...
Back
Top Bottom