[mso] Re: Access - Help getting related fields to show

  • From: "Ray Blake" <ray@xxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Sun, 20 Jun 2004 08:29:21 +0100

Not quite with you, Dian, show where? In a query? On a form?

Ray

------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Dian Chapman
Sent: 20 June 2004 03:43
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access - Help getting related fields to show


Hi folks...

As you may remember, I'm much better writing data to Access from the
backdoor...then through the front. But in this instance, I need to setup
= the DB through the GUI, properly, so I can explain the process to
someone = after I write the backend code. But I'm used to making data
show up anyway I want...without Access. So making Access bend to my will
isn't my best = skill. So I'd appreciate any help with this scenario.
Note...I have the sample = DB available if any brave soul wants to check
it out if my explanation = stinks!
;-)

It's a pretty basic DB. Four tables...Clients, Invoices, InvoiceDetails
= and InventoryItems...relations linked appropriately showing
InventoryItems = in the InvoiceDetails when sold...the details related
to the same invoice. = The invoices related to the clients.

However, when I select an item to add to the Invoice details...I pick =
the name of the item and would also like the current cost to show. I
have it currently TOGETHER with the item name. But that's not quite want
I want...and I don't know how to get what I want.

Say I choose (and these prices samples here) a license for Office. In =
the inventory table, it shows the ItemID, ItemName, SKU and Price. So
when I select Office...I'd like to see the price, at least for that
item. = However, I don't get the plus sign to allow me to see those
details...and I don't know why...what do I have to do to properly link
that up??? The others = all show links to display the info...not that
one?

Anyway, I thought, well, I'll just have the price display in that field,
too. So I click on Office and next to it...in another column...is the =
price. But that doesn't display in the row, I must click the drop down
to see = it. And this doesn't really seem the right way to do this?=20

So I can open the Client table and expand to see the sub table to see =
all their invoices. Cool. And I can click on the invoice to see all the
= details of the items in that invoice. Right. But I can't click on the
purchased = item to expand to see the cost/sku details...which I'd like.
OR...have those fields display in some way in the details table.

But I=92m lost! Any clues what I screwed up? Hope SOMEONE can understand
= this.

TIA...

=09
Dian D. Chapman
Technical Consultant, Instructor
Microsoft MVP & MOS Expert Certified=20

Free MS Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA
the easy way, thru video! www.mousetrax.com/techcourses.html


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: