Hi All,
A have a table, let's call it ONE and I would like to import data though a form.
I want also the two colums of this table to be filled with data from another table, let's call it TWO, where the DATE and the CODE meet the criteria.
It may sound very easy to some of you but I am not very familiar with databases.
Every help is appreciated!
COLUMS OF TABLE ONE (On the first two columns I want to enter the new data and when these criteria meet the data form an another table I want the columns three and four to be filled with the existing data from a second table)
ONE.DATE - ONE.CODE - TWO.VALUE1 - TWO.VALUE2 - ONE.VALUE3
Thanks!
A have a table, let's call it ONE and I would like to import data though a form.
I want also the two colums of this table to be filled with data from another table, let's call it TWO, where the DATE and the CODE meet the criteria.
It may sound very easy to some of you but I am not very familiar with databases.
Every help is appreciated!
COLUMS OF TABLE ONE (On the first two columns I want to enter the new data and when these criteria meet the data form an another table I want the columns three and four to be filled with the existing data from a second table)
ONE.DATE - ONE.CODE - TWO.VALUE1 - TWO.VALUE2 - ONE.VALUE3
Thanks!