[mso] Re: Access - Help getting related fields to show
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 20 Jun 2004 16:16:35 -0500
Sorry...in the tables.
You know that when you have the relationships setup correctly, you can see
the + sign to expand a related table and have that info displayed...well,
I'm not getting that for the last one and not sure how I messed up the
relationship to cause the problem...if that where I messed up?
Wait...I'll put together a little page on my web to show pics and get back
with the URL.
Thanks, Ray!
Dian D. Chapman
Technical Consultant, Instructor
Microsoft MVP & MOS Expert Certified
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
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Ray Blake
Sent: Sunday, June 20, 2004 2:29 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access - Help getting related fields to show
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
*************************************************************
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.708 / Virus Database: 464 - Release Date: 6/18/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.708 / Virus Database: 464 - Release Date: 6/18/2004
*************************************************************
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:
