Toukey-
If you get no rows from that query, then there are no values in tblFireClms in
the loss_type field that match any values in tbllosstype. Didn't you say you
were entering data in a claims form? If so, then why are you joining the claims
data with the loss type data if none of the loss types are filled in for the
claims table?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
Sent: Saturday, June 23, 2012 8:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Help! - Amendment to form
This is the SQL view of the query
SELECT tblFireClms.*
FROM tblFireClms INNER JOIN tbllosstype ON tblFireClms.loss_type =
tbllosstype.loss_type;
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> And more to the point, what is the SQL of your Row Source query?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> Sent: Friday, June 22, 2012 10:30 PM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Subject: RE: [MS_AccessPros] Help! - Amendment to form
>
>
> Is it a left join? right join? inner join?
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
> Sent: Friday, June 22, 2012 1:25 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Help! - Amendment to form
>
> Hi,
>
> I am at the point where frustration is setting in as I cannot get this simple
> thing to work.
>
> I have a form that was working but now the user wants to include a new
drop-down
> field. No problem I thought. I then proceeded to create a new table which I
have
> called LossType and I have 3 fields which are:
>
> seqno (auto number - primary key), loss_type (Text) and ins_type (Text).
>
> ins_type is an existing field from another table as the user wants to be able
> when entering data on the form, to only display the loss type for only that
> particular ins_type.
>
> I created a form based on the LossType table and entered the relevant info. I
> then proceeded to my existing claim form to add the combobox for the
loss_type.
> I had to create a query based on the claim and loss type tables and did a join
> on the loss_type fields.
>
> The problem when I view the results in the query I am getting no data. When I
> remove the join the data is duplicated.
>
> Please help!
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you are
> not the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
>
Tidak ada komentar:
Posting Komentar