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