Access Form/Report Issue with fields

[Bulldog]

Posted in Access Tables but I think it should be here. Here's my
scenario.

I've got an tblAsset that has a list of assets. The key field is
obviously Asset Number which will be unique to each record. What I
am
needing to do is pull up an Asset, and add assets under that one
particular assets. Example, I have a building asset which I want
fixture assets to fall under to show where those assets are. With
that said, I've created a tblContents table that simply has these
fields: id (autonumber PK), asset number, content number (the sub
asset numbers). This concept would work fine but I want to be able
to
pull description and value for the subassets on forms, and reports
but
this won't allow me. It pulls the Main asset's description and value
instead. I didn't really want to put the description and value in
the
tblContents just to avoid duplicate data in the database. Any
suggestions are greatly appreciated!!! Sorry for the long post!

 

[Carl Rapson]

Posted in Access Tables but I think it should be here. Here's my
scenario.

I've got an tblAsset that has a list of assets. The key field is
obviously Asset Number which will be unique to each record. What I
am
needing to do is pull up an Asset, and add assets under that one
particular assets. Example, I have a building asset which I want
fixture assets to fall under to show where those assets are. With
that said, I've created a tblContents table that simply has these
fields: id (autonumber PK), asset number, content number (the sub
asset numbers). This concept would work fine but I want to be able
to
pull description and value for the subassets on forms, and reports
but
this won't allow me. It pulls the Main asset's description and value
instead. I didn't really want to put the description and value in
the
tblContents just to avoid duplicate data in the database. Any
suggestions are greatly appreciated!!! Sorry for the long post!

You don't say how you're trying to pull the subasset description and value,
but it sounds like you've joined tblAsset to tblContents on the asset
number, when you should be joining them on the content number (which, I
assume, is also an asset number in tblAssets).

Carl Rapson