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