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!
Tidak ada komentar:
Posting Komentar