Form - Relating two tables

[Brian T]

Hello,

I am trying to create a project progress form. The is completed twice a
month.
I have created a table that has the periods as follows:

Report Num Period Start Period End
------------------------------------------------------
1 01 Jan 10 15 Jan 10
2 16 Jan 10 31 Jan 10
etc....

The second table has the work items in the project:

Item # Work Desc. % Total % this Period % Cumulativ
--------------------------------------------------------------------------------
1 Strip Site 5% 1% 1%
2 Build Building 95% 0% 0%

How do I relate these two tables into a single form?

Thanks

 

[Douglas J. Steele]

Base the form on a query that joins the two tables.

 

[KARL DEWEY]

How do I relate these two tables into a single form?
You have to have something that is common to the two tables. I do not see
anything that is common.

Now if each [Item #] in the second table had a date associated with it then
you could match it between the Period Start and Period End dates of table one.

Or if each [Item #] in the second table had an amount of time to be
accomplished and you hace a start date then you could calculate the date
needed for the above relationship.

 

[De Jager]

You have to have something that is common to the two tables. I do not see
anything that is common.

Now if each [Item #] in the second table had a date associated with it
then
you could match it between the Period Start and Period End dates of table
one.

Or if each [Item #] in the second table had an amount of time to be
accomplished and you hace a start date then you could calculate the date
needed for the above relationship.

--
Build a little, test a little.

Hello,

I am trying to create a project progress form. The is completed twice a
month.
I have created a table that has the periods as follows:

Report Num Period Start Period End
------------------------------------------------------
1 01 Jan 10 15 Jan 10
2 16 Jan 10 31 Jan 10
etc....

The second table has the work items in the project:

Item # Work Desc. % Total % this Period % Cumulative
--------------------------------------------------------------------------------
1 Strip Site 5% 1%
1%
2 Build Building 95% 0%
0%

How do I relate these two tables into a single form?

Thanks