Unbound Text field in continous form

  • Thread starter Thread starter mrdonofrio
  • Start date Start date
M

mrdonofrio

Hi,

I have tried looking in all the groups but cannot find an answer to
this - i'm either blind or it's not obvious.

I have a continous form which lists assets, each asset has multiple
owners. I would like to display the owners details such as division
and tel number in a text box on the same line as the asset. Currently
if i add the owner it then double up the assets in the form.

I hope you can help as it is driving me mad.

Marc
 
mrdonofrio,
Since an Asset can have multiple owners, the owners can not be included in the Asset
subform. Assets should be in one table , and owners in another, related by Assets(One) to
Owners(Many).
You would need another subform for Owners, Linked (Parent(Assets) to Child(Owners))
If you try to include Owners in the Assets subform, you'll see just what you see...
Assets duplicating, in order to satisfy the realtionship.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Thanks Al, The problem with using a sub form is that you cannot use
one on a continuos form. I know dlookups can be used on unbound fields
to get the information for one owner, however is there a was to
programatically get the info into an unbound text box?
 
Please don't <snip> the previous posts on this thread. It's helpful to see the whole
problem in one post.
Some judicious snipping of space and non critical text is OK, but leave the gist... Thanks

I didn't mean a continuous subform "inside" another continuous subform.
I meant another separate subform, linked to the Asset subform via some key value like
AssetNo or AssetID.

For example, I have an app that let's me place my cursor in a subform (containing
Classes).
If I place my cursor in any Class record...
another, separate, subform shows all the people enrolled in that Class.

There are other ways to handle this problem, this is just the one I happen to use...
(Give Douglas Steele's suggestion a go too...)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top