Link between Tables

[Geoffk]

Hi All

I enter data in a form "WIP" that is based on a table named "WIP" in the form I have a command button. When I activate the command button it takes me into another form "Materials" which is based on a table named "Materials".

The data that I enter into "Materials" is not linked to the data ie Customer details which I have entered into "WIP".

My aim is to be able to report the materials used.

I have tried variations of relationships but am obviously missing something.

Thanks in Advance

Geoffk

 

[MicroE]

You should design Materials as a sub form of WIP (Main Form).

http://office.microsoft.com/en-us/access/HA100986741033.aspx?pid=CH100645661033

 

[Geoffk]

Thanks MicroE I give it a go

Geoffk