Recent content by Ayshan

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

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...

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...

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...

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...

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

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...