G
Gina
I want to build a subform within a subform. I have the following
tables.
tbl-Clients
ClientCode (Pri Key)
ClientName
tbl-Jobs
JobNumber (Pri Key)
JobName
ClientCode
tbl-TimeCards
Time-ID (Pri Key)
Date
Time On
Time Off
JobNumber
TaskCode
tbl-Tasks
TaskCode (Pri Key)
TaskName
TaskRate
tbl-Expenses
Expenses-ID (Pri Key)
Date
ExpAmount
ExpDetails
JobNumber
The three levels of the form I will call Child, Parent and
Grandparent.
I need to have the 'Grandparent' form built from 'tbl-Clients' with
the record in Form view. This is to enable the Parent generation
records to be displayed in Datasheet view.
The Parent Form/Subform is to be built from 'tbl-Jobs'. Then when a
'Parent' record is selected, the respective child records are to be
displayed in Datasheet view.
I want to have the Child form built from a combination of 'tbl-Tasks'
and 'tbl-TimeCards' without repeating 'TaskCode'.
I have been working on this for days and in the process learnt quite a
lot, ... .but not how to do it.
Appreciate any help you may offer.
With thanks,
Gina
tables.
tbl-Clients
ClientCode (Pri Key)
ClientName
tbl-Jobs
JobNumber (Pri Key)
JobName
ClientCode
tbl-TimeCards
Time-ID (Pri Key)
Date
Time On
Time Off
JobNumber
TaskCode
tbl-Tasks
TaskCode (Pri Key)
TaskName
TaskRate
tbl-Expenses
Expenses-ID (Pri Key)
Date
ExpAmount
ExpDetails
JobNumber
The three levels of the form I will call Child, Parent and
Grandparent.
I need to have the 'Grandparent' form built from 'tbl-Clients' with
the record in Form view. This is to enable the Parent generation
records to be displayed in Datasheet view.
The Parent Form/Subform is to be built from 'tbl-Jobs'. Then when a
'Parent' record is selected, the respective child records are to be
displayed in Datasheet view.
I want to have the Child form built from a combination of 'tbl-Tasks'
and 'tbl-TimeCards' without repeating 'TaskCode'.
I have been working on this for days and in the process learnt quite a
lot, ... .but not how to do it.
Appreciate any help you may offer.
With thanks,
Gina