Search results

  1. A

    adding new record to a form

    I tried to use tabs but just could not configure relationships between them
  2. A

    adding new record to a form

    I thought it is because my data sources are different. I will try to add information vice versa as you suggested. What about if I combine my two tables and make it one table and create two forms (parent and subform). Do you think it could solve my problem. I am trying to do it in the main and...
  3. A

    adding new record to a form

    Hi I am new to Access and I was trying to create database for chemical inventory handling I have two tables. one of my tables (chemical info) has information on chemical properties. I used "Cas NO" as primary key. I have another fields such as "chemical name", 'product number" and etc. In...
  4. A

    adding new record to a form

    Hi I am new to Access and I was trying to create database for chemical inventory handling I have two tables. one of my tables (chemical info) has information on chemical properties. I used "Cas NO" as primary key. I have another fields such as "chemical name", 'product number" and etc. In...
  5. A

    Joining unrelated data in one table

    What I am planning to do is gather requirements for chemicals from different labs. Chemicals name is likely to be fixed, but amounts required will change and it is expected to receive new requirements for chemicals every month. So I need to establish a system where I will be able to see which...
  6. A

    Joining unrelated data in one table

    Yes all of 3 tables structures will be the same. Chemicals Name AMount Required Equipments Present Equipments Needed I am planning to have these columns for all three and I would like to extract Chemical Name, Amount required Columns
  7. A

    Joining unrelated data in one table

    Hi I have tried to combine data from 3 different tables (unrelated) to make a new one. However, as I understood I can not do this because these 3 tables are unrelated. In my case my 3 tables are for 3 labs' material requirements. I am planning that each lab will fill a form which directly...
Back
Top Bottom