How do I use one record to describe a table

[Bob Sanderson]

I have a table which pertains to an assembly and the individual records of
the table pertain to the components of the assembly. I need one record to
contain information pertaining to the assembly only (Job Number,
Description, etc.). I want this information to appear in the header and
footer of a report. How do I accomplish this?

Thanks in advance.

[Bob Sanderson]

"Rick Brandt" <ri*********@hotmail.comwrote in
news:Iw*****************@newssvr11.news.prodigy.ne t:

You indicated you wanted to do this with a single table. You need two
tables. One for assemblies and one for components.

How do I link the two together? I still have to have a unique record in the
components table to link to the assemblies table.

[Rick Brandt]

Bob Sanderson wrote:

"Rick Brandt" <ri*********@hotmail.comwrote in
news:Iw*****************@newssvr11.news.prodigy.ne t:

You indicated you wanted to do this with a single table. You need
two tables. One for assemblies and one for components.

How do I link the two together? I still have to have a unique record
in the components table to link to the assemblies table.

The components table needs to include a field for the assembly identifier. It
will be a foriegn key in the components table and you relate it to the primary
key in the assemblies table.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Bob Sanderson]

"Rick Brandt" <ri*********@hotmail.comwrote in
news:wC******************@newssvr11.news.prodigy.n et:

The components table needs to include a field for the assembly
identifier. It will be a foriegn key in the components table and you
relate it to the primary key in the assemblies table.

That's pretty much the problem I have now. Where do I put the foreign key?
Does it have to be attached to every record?

[Rick Brandt]

Bob Sanderson wrote:

"Rick Brandt" <ri*********@hotmail.comwrote in
news:wC******************@newssvr11.news.prodigy.n et:

The components table needs to include a field for the assembly
identifier. It will be a foriegn key in the components table and
you relate it to the primary key in the assemblies table.

That's pretty much the problem I have now. Where do I put the foreign
key? Does it have to be attached to every record?

Yep, but if you use a form with a subform Access will do that for you
automatically.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Bob Sanderson]

"Rick Brandt" <ri*********@hotmail.comwrote in news:yQk0j.60246$RX.23714
@newssvr11.news.prodigy.net:

Bob Sanderson wrote:

That's pretty much the problem I have now. Where do I put the foreign

>key? Does it have to be attached to every record?

Yep, but if you use a form with a subform Access will do that for you
automatically.

Thanks, I'll give that a try

[Bob Sanderson]

"Rick Brandt" <ri*********@hotmail.comwrote in news:yQk0j.60246$RX.23714
@newssvr11.news.prodigy.net:

Bob Sanderson wrote:

That's pretty much the problem I have now. Where do I put the foreign

>key? Does it have to be attached to every record?

Yep, but if you use a form with a subform Access will do that for you
automatically.

Thanks, I'll give that a try