You could relate the asset id of computer reg with asset id of the table
where you have the description.Design a query selecting required fileds from
both tables and source it on to a form.
Krishnadas Rai
On 23/02/06, Ilona Wright <[EMAIL PROTECTED]> wrote:
>
> Hi there,
> I am using ACCESS 97 and am trying to add a Computer Register to an
> existing Assets tracking system.
> My Assets table is called Assets and amongst other fields it contains
> AssetId (auto number)
> AssetDescription (text)
>
> My Computer Register consists of 3 tables
>
> Table: ComputerReg ... for general information
> CRID (auto number)
> AssetId (linked to Assets.AssetId one to one relationship)
> other text fields
>
> Table: ComputerRegH ... contains hardware details
> CRIDH (auto number)
> CRID (linked to ComputerReg.CRID one to many relationship)
> other text fields
>
> Table ComputerRegS ... contains software details
> CRIDS (auto number)
> CRID (linked to ComputerReg.CRID one to many relationship)
> other text fields
>
> In the Assets form I have a button that opens the ComputerRegister form
> and
> I want the AssetId and AssetDescription from the Assets form to display at
> the top of the ComputerRegister form.
> I can get the AssetId passed from the Assets form to the ComputerRegister
> form and it is saved on the ComputerReg table, but I cannot get the
> description to display.
> I can key in (ie add) a ComputerReg record and it is saved with the
> correct
> AssetId, but it does not display (ie does not seem to be retrieved) when I
> call up the ComputerRegister form for editing.
>
> Can you help me please?
> Thank you very much
> Ilona Wright
> Adelaide, Australia
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
T.Krishnadas Rai
"RAI's" 101, 3rd C Cross
1st G Main, East of NGEF,
Kasturinagar
Bangalore-560043
Ph: 25425635 (R)
25660524(O)
9845061899 (Mob)
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
