How to build the relation of fields in microsoft access table?

  • Thread starter J.A.Pandya - Mechanical Maint. Engineer
  • Start date
J

J.A.Pandya - Mechanical Maint. Engineer

I am using Microsoft Access 2003. In the access table I want to establish
relation between two fields of the same table. How can I do this?
 
S

Steve Schapel

J.A.Pandya,

Can you please give some more information, maybe with some example,
about what is meant by "establish relation between two fields of the
same table"? Thank you.
 
J

J.A.Pandya - Mechanical Maint. Engineer

Dear Steve,
At present I am working on technical inspection database. I have following
fields in the table.
1) Visual Inspection date
2) No of days for next Visual Inspection for Class-I
3) Next visual inspection due date.
The requirement is this visual inspection should be conducted every year, so
I have fix the default value 365 days for "No of days for next visual
inspection for class-I" field. Now I have prepare a form with Next visual
inspection due date and I have fix the data control source of this field with
"=Abs([Visual Inspection date]+[No of days for next Visual Inspection for
Class-I])" Equation.
Now I am getting the next due date automatically after entering Visual
Inspection date in form. But this next visual inspection date is not
appearing in table means this date is not being store in table. So I was
thinking to give data control source (relation) to fields of the table. Is it
possible to give such relation to fields of table?
 
J

J.A.Pandya - Mechanical Maint. Engineer

Dear Joseph,
At present I am working on technical inspection database. I have following
fields in the table.
1) Visual Inspection date
2) No of days for next Visual Inspection for Class-I
3) Next visual inspection due date.
The requirement is this visual inspection should be conducted every year, so
I have fix the default value 365 days for "No of days for next visual
inspection for class-I" field. Now I have prepare a form with Next visual
inspection due date and I have fix the data control source of this field with
"=Abs([Visual Inspection date]+[No of days for next Visual Inspection for
Class-I])" Equation.
Now I am getting the next due date automatically after entering Visual
Inspection date in form. But this next visual inspection date is not
appearing in table means this date is not being store in table. So I was
thinking to give data control source (relation) to fields of the table. Is it
possible to give such relation to fields of table?
 
Top