Asset and Contracts help required

[don]

Hi,

I have an assets and a contracts table in my db and would like to be
able to display all of my assets for a given asset group so these
could be selected and added as items for a given years contract. I
have a qry that filters my list to asset group but have drawn a blank
on how to pass this information to my contracts table. its current
format being

ID Contract ID Asset ID

My knowledge of access is rather rusty and was never very deep and am
using Access 2003. Any help would be appreciated.

Many thanks

DonH

 

[Piet Linden]

Hi,

I have an assets and a contracts table in my db and would like to be
able to display all of my assets for a given asset group so these
could be selected and added as items for a given years contract.  I
have a qry that filters my list to asset group but have drawn a blank
on how to  pass this information to my contracts table. its current
format being

ID Contract ID Asset ID

My knowledge of access is rather rusty and was never very deep and am
using Access 2003.  Any help would be appreciated.

Many thanks

DonH

show all assets for a given asset group... filter your combobox based
on another...
http://www.mvps.org/access/forms/frm0028.htm
What does this have to do with the table? If you display the data in
the form and bind the form to the table, your selections will be
saved...

 

[don]

show all assets for a given asset group... filter your combobox based
on another...http://www.mvps.org/access/forms/frm0028.htm
What does this have to do with the table?  If you display the data in
the form and bind the form to the table, your selections will be
saved...

Thanks for the reply, not sure if I understand.

My asset qry returns a list of printers for example, some may be in
warranty, therefore not required as part of a service contract, and
other might be serviced by different contract levels of cover, I
therefore need to be able to selectively add printers to my contracts
table. If I've missed your point can you please expand.

Many thanks

Don

 

[Mark Andrews]

Sounds like you need a table with:
- ContractAssetID autonumber key
- ContractID Long
- AssetID Long

Use this new table in a subform to selectively add multiple associations
between contract and assets.
If you need to make the selection of the assetid on this table fancier such
as using a combobox to select an asset group which then displays a combo box
of just assets in that asset group you can do that as well.

Checkout allen brownes webiste for code to do multiple comboboxes than are
linked.

Start with the subform and a combo box to just select the asset (link
subform to main form by contractid).

HTH,
Mark
RPT Software
http://www.rptsoftware.com